sawo11 님의 블로그

오늘부터 다시 코테 연습 시작!!나는..취업할 수 있다......!🥹문제 풀이 링크: https://datalemur.com/questions/sql-swapped-food-delivery Zomato SQL Interview Question | DataLemurZomato SQL Interview Question: Write a query to correct the swapping food order error and return the proper pairing of order ID and item.datalemur.com🔹 해결해야 할 일:뒤바뀐 아이템들을 원래의 순서로 복원짝수/홀수 번호에 따라 아이템을 서로 교환마지막 주문이 홀수일 경우 → 짝이 없기 때문에 그대로 유지WITH order_c..

Given a table of Facebook posts, for each user who posted at least twice in 2021, write a query to find the number of days between each user’s first post of the year and last post of the year in the year 2021. Output the user and number of the days between each user's first and last post.p.s. If you've read the Ace the Data Science Interview and liked it, consider writing us a review?posts Table..

This is the same question as problem #3 in the SQL Chapter of Ace the Data Science Interview!Assume you're given the table on user viewership categorised by device type where the three types are laptop, tablet, and phone.Write a query that calculates the total viewership for laptops and mobile devices where mobile is defined as the sum of tablet and phone viewership. Output the total viewership ..

Tesla is investigating production bottlenecks and they need your help to extract the relevant data. Write a query to determine which parts have begun the assembly process but are not yet finished.Assumptions:parts_assembly table contains all parts currently in production, each at varying stages of the assembly process.An unfinished part is one that lacks a finish_date.This question is straightfo..

Assume you're given two tables containing data about Facebook Pages and their respective likes (as in "Like a Facebook Page").Write a query to return the IDs of the Facebook pages that have zero likes. The output should be sorted in ascending order based on the page IDs.pages Table: ColumnNameTypepage_namevarcharpage_idintegerpages Example Input:page_idpage_name20001SQL Solutions20045Brain Exerc..

Given a table of candidates and their skills, you're tasked with finding the candidates best suited for an open Data Science job. You want to find candidates who are proficient in Python, Tableau, and PostgreSQL.Write a query to list the candidates who possess all of the required skills for the job. Sort the output by candidate ID in ascending order. Assumption:There are no duplicates in the can..

Assume you're given a table Twitter tweet data, write a query to obtain a histogram of tweets posted per user in 2022. Output the tweet count per user as the bucket and the number of Twitter users who fall into that bucket.In other words, group the users by the number of tweets they posted in 2022 and count the number of users in each group.tweets Table: ColumnNameTypetweet_idintegeruser_idinteg..

주말에 다시 한번 복습하며 작성하는 QCC 오답 🌧️문제1 (X)2012년 이후 개봉한 영화 중, 장르가 2개 이상 포함된 영화의 연도별 매출을 구하는 SQL 문을 작성해주세요. 단, 해당 영화는 최소 100개 이상의 평점 수를 받은 경우만 결과에 포함해주세요. 결과는 개봉 연도를 기준으로 오름차 정렬해야 합니다.SELECT release_year, SUM(revenue) revenue -- 연도별 매출이므로 SUMFROM moviesWHERE release_year >= 2012AND JSON_LENGTH(genres) >= 2AND vote_count >= 100 GROUP BY release_yearORDER BY release_year ;JSON_LENGTH(*) 함수: JSON 객체나 배열의..

Rising TemperatureTable: Weather+---------------+---------+| Column Name | Type |+---------------+---------+| id | int || recordDate | date || temperature | int |+---------------+---------+id is the column with unique values for this table.There are no different rows with the same recordDate.This table contains information about the temperature on a certain day. W..

어쩌다보니 3회차보다 빨리 오답을 하게 된 4회차...😅어제 SQL로 데이터 분석을 해봤던게 도움이 됐던 것 같다!문제1 (O)지역별로 매출이 가장 높은 매장의 매출을 조회하는 SQL 문을 작성해주세요. 단, 해당 지역에 매장이 두 개 이상인 경우만 결과에 포함해주세요. 결과는 지역 이름을 기준으로 오름차순으로 정렬해주세요.SELECT REGION_NAME region_name, MAX(SALES) highest_salesFROM storesGROUP BY REGION_NAMEHAVING COUNT(STORE_ID) >= 2ORDER BY region_name;문제2 (X)최근 특정 사용자들이 결제를 하지 않고 상품을 주문하거나, 결제를 하지 않은 시점에 이미 상품을 주문하는 버그가 발견되었습니다. ?..