#109. [LeetCode / MySQL] 1204. Last Person to Fit in the Bus

문제 입력 코드 SELECT q1.person_name FROM Queue AS q1 JOIN Queue AS q2 ON q1.turn >= q2.turn GROUP BY q1.turn HAVING SUM(q2.weight)

• format_list_bulleted SQL
• · 2023. 10. 5.
• 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

#104. [LeetCode / MySQL] 1731. The Number of Employees Which Report to Each Employee

문제 입력 코드 SELECT e2.employee_id, e2.name, COUNT(*) AS reports_count, ROUND(AVG(e1.age)) AS average_age FROM Employees AS e1 INNER JOIN Employees AS e2 ON e1.reports_to = e2.employee_id GROUP BY e2.employee_id, e2.name ORDER BY e2.employee_id 코드 설명 #SELECT #COUNT #ROUND #AVG #INNER JOIN #GROUP BY #ORDER BY 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your codi..

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

#101. [LeetCode / MySQL] 1729. Find Followers Count

문제 입력 코드 SELECT user_id, COUNT(follower_id) AS followers_count FROM Followers GROUP BY user_id ORDER BY user_id ASC; 코드 설명 #SELECT #COUNT #GROUP BY #ORDER 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. 27.
• textsms

#92. [LeetCode / MySQL] 1633. Percentage of Users Attended a Contest

문제 입력 코드 SELECT contest_id, ROUND(COUNT(DISTINCT user_id)/(SELECT COUNT(user_id) FROM Users) * 100, 2) AS percentage FROM Register GROUP BY contest_id ORDER BY percentage DESC, contest_id ASC; 코드 설명 #SELECT #ROUND #COUNT #DISTINCT #GROUP BY #ORDER BY 문제 출처 Percentage of Users Attended a Contest - LeetCode Can you solve this real interview question? Percentage of Users Attended a Contest - Table:..

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