#108. [LeetCode / MySQL] 1164. Product Price at a Given Date

문제 입력 코드 SELECT DISTINCT product_id, 10 AS price FROM Products WHERE product_id NOT IN (SELECT DISTINCT product_id FROM Products WHERE change_date

• format_list_bulleted SQL
• · 2023. 10. 4.
• textsms

#107. [LeetCode / MySQL] 180. Consecutive Numbers

문제 입력 코드 1. SELECT DISTINCT a.num AS ConsecutiveNums FROM Logs AS a JOIN Logs AS b ON (a.id = b.id + 1) AND (a.num = b.num) JOIN Logs AS c ON (b.id = c.id + 1) AND (b.num = c.num) 2. WITH cte AS ( SELECT num, LAG(num) OVER (ORDER BY id) AS prev_num, LEAD(num) OVER (ORDER BY id) AS next_num FROM Logs ) SELECT num AS ConsecutiveNums FROM cte WHERE num = prev_num AND num = next_num GROUP BY num; 코드..

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

#105. [LeetCode / MySQL] 1789. Primary Department for Each Employee

문제 입력 코드 1. SELECT employee_id, department_id FROM Employee GROUP BY employee_id HAVING COUNT(employee_id) = 1 UNION SELECT employee_id, department_id FROM Employee WHERE primary_flag = 'Y' 2. SELECT DISTINCT employee_id, department_id FROM Employee WHERE employee_id IN ( SELECT employee_id FROM Employee GROUP BY employee_id HAVING COUNT(*) = 1 ) OR primary_flag = 'Y' ORDER BY employee_id; 코드 설명..

• format_list_bulleted SQL
• · 2023. 10. 1.
• textsms

#103. [LeetCode / MySQL] 1045. Customers Who Bought All Products

문제 입력 코드 SELECT customer_id FROM Customer GROUP BY customer_id HAVING COUNT(DISTINCT(product_key)) = (SELECT COUNT(product_key) FROM Product); 코드 설명 #SELECT #GROUP BY #HAVING #COUNT #DISTINCT 문제 출처 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 for your next i..

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

#98. [LeetCode / MySQL] 1141. User Activity for the Past 30 Days I

문제 입력 코드 SELECT activity_date AS day, COUNT(DISTINCT user_id) AS active_users FROM Activity WHERE (activity_date > "2019-06-27" AND activity_date

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

#97. [LeetCode / MySQL] 2356. Number of Unique Subjects Taught by Each Teacher

문제 입력 코드 SELECT teacher_id, COUNT(DISTINCT(subject_id)) AS cnt FROM Teacher GROUP BY teacher_id; 코드 설명 #SELECT #COUNT #DISTINCT #GROUP BY 문제 출처 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 for your next interview. leetcode.com

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