#112. [LeetCode / MySQL] 626. Exchange Seats

문제  입력 코드1. SELECT CASE WHEN id = (SELECT MAX(id) FROM Seat) AND (id % 2 = 1) THEN id WHEN id % 2 = 1 THEN id + 1 ELSE id - 1 END AS id, studentFROM SeatORDER BY id;  2. SELECT S.id, IFNULL( IF(S.id % 2 = 0, (SELECT student FROM Seat WHERE id = S.id - 1), (SELECT student FROM Seat WHERE id = S.id + 1) ..

• format_list_bulleted SQL
• · 2024. 6. 17.
• textsms

#111. [LeetCode / MySQL] 1978. Employees Whose Manager Left the Company

문제  입력 코드1. SUBQUERYSELECT employee_id FROM EmployeesWHERE salary   2. LEFT JOINSELECT e1.employee_id FROM Employees AS e1LEFT JOIN Employees AS e2ON e1.manager_id = e2.employee_idWHERE e1.salary   코드 설명#SELECT #WHERE #NOT IN #ORDER BY #LEFT JOIN # JOIN #NULL #AS #ON  문제 출처https://leetcode.com/problems/employees-whose-manager-left-the-company/description/?envType=study-plan-v2&envId=top-sql-50

• format_list_bulleted SQL
• · 2024. 6. 17.
• textsms

#110. [LeetCode / MySQL] 1907. Count Salary Categories

문제 입력 코드 (SELECT "Low Salary" AS category, (SELECT COUNT(account_id) FROM Accounts WHERE income = 20000 and income 50000) AS accounts_count) 코드 설명 #SELECT #COUNT #UNION #UNION ALL 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your ..

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

#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

#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