[LeetCode] 183. Customers Who Never Order [문제] [MySQL]SELECT c.name AS CustomersFROM Customers AS c LEFT JOIN Orders AS o ON c.id = o.customerIDWHERE o.id IS NULL SQL/LeetCode 2025.02.17
[LeetCode] 182. Duplicate Emails [문제] [MySQL]WITH duplicate_nums AS ( SELECT email , COUNT(DISTINCT id) AS duplicate_num FROM Person GROUP BY email)SELECT email AS EmailFROM duplicate_numsWHERE duplicate_num > 1 SQL/LeetCode 2025.02.17
[LeetCode] 181. Employees Earning More Than Their Managers [문제] [MySQL]SELECT e1.name AS EmployeeFROM Employee AS e1 INNER JOIN Employee AS e2 ON e1.managerID = e2.idWHERE e1.salary > e2.salary SQL/LeetCode 2025.02.17
[LeetCode] 180. Consecutive Numbers [문제] [MySQL]SELECT DISTINCT num AS ConsecutiveNumsFROM ( SELECT num , LEAD(num, 1) OVER (ORDER BY id) AS num_1_after , LEAD(num, 2) OVER (ORDER BY id) AS num_2_after FROM Logs) AS nums_listWHERE num = num_1_after AND num_1_after = num_2_after SQL/LeetCode 2025.02.17
[LeetCode] 178. Rank Scores [문제] [MySQL]SELECT score , DENSE_RANK() OVER (ORDER BY score DESC) AS 'rank'FROM Scores SQL/LeetCode 2025.02.17
[LeetCode] 176. Second Highest Salary [문제] [MySQL]SELECT MAX(salary) AS SecondHighestSalaryFROM EmployeeWHERE salary SQL/LeetCode 2025.02.17
[LeetCode] 175. Combine Two Tables [문제] [MySQL]SELECT p.firstName , p.lastName , a.city , a.stateFROM Person AS p LEFT JOIN Address AS a ON p.personID = a.personID SQL/LeetCode 2025.02.17
