#99. [LeetCode / MySQL] 1070. Product Sales Analysis III

문제 입력 코드 SELECT product_id, year AS first_year, quantity, price FROM Sales WHERE (product_id, year) in ( SELECT product_id, MIN(year) FROM Sales GROUP BY product_id ) 코드 설명 #SELECT #MIN #GROUP BY #SUBQUERY 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared f..

• format_list_bulleted SQL
• · 2023. 9. 25.
• textsms

#96. [LeetCode / MySQL] 550. Game Play Analysis IV

문제 입력 코드 SELECT ROUND(COUNT(DISTINCT player_id)/(SELECT COUNT(DISTINCT player_id) FROM Activity), 2) AS fraction FROM Activity WHERE (player_id, DATE_SUB(event_date, INTERVAL 1 DAY)) IN ( SELECT player_id, MIN(event_date) AS first_login FROM Activity GROUP BY player_id ) 코드 설명 #SELECT #ROUND #COUNT #DISTINCT #DATE_SUB #INTERVAL #MIN #GROUP BY 문제 출처 Game Play Analysis IV - LeetCode Can you solve ..

• format_list_bulleted SQL
• · 2023. 9. 22.
• textsms

#95. [LeetCode / MySQL] 1174. Immediate Food Delivery II

문제 입력 코드 SELECT ROUND(AVG(order_date = customer_pref_delivery_date) * 100, 2) AS immediate_percentage FROM Delivery WHERE (customer_id, order_date) IN ( SELECT customer_id, MIN(order_date) FROM Delivery GROUP BY customer_id ) 코드 설명 #SELECT #ROUND #AVG #MIN #GROUP BY #SUBQUERY 문제 출처 Immediate Food Delivery II - LeetCode Can you solve this real interview question? Immediate Food Delivery II - Tabl..

• format_list_bulleted SQL
• · 2023. 9. 21.
• textsms

#28. SUM, MIN, MAX : 최솟값 구하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. MIN SELECT MIN(DATETIME) AS 시간 FROM ANIMAL_INS; 2. ORDER BY, LIMIT SELECT DATETIME AS "시간" FROM ANIMAL_INS ORDER BY DATETIME ASC LIMIT 1; 코드 설명 #SELECT #MIN #ORDER BY #LIMIT 문제 출처 https://school.programmers.co.kr/learn/courses/30/lessons/59038

• format_list_bulleted SQL
• · 2023. 8. 3.
• textsms

#18. SELECT : 상위 n개 레코드 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. LIMIT SELECT NAME FROM ANIMAL_INS ORDER BY DATETIME LIMIT 1; 2. MIN SELECT NAME FROM ANIMAL_INS WHERE DATETIME = (SELECT MIN(DATETIME) FROM ANIMAL_INS) 코드 설명 #SELECT #ORDER BY #LIMIT #MIN 문제 출처 https://school.programmers.co.kr/learn/courses/30/lessons/59405

• format_list_bulleted SQL
• · 2023. 7. 29.
• textsms