Im between cherry

183. Customers Who Never Order https://leetcode.com/problems/customers-who-never-order/ Customers Who Never Order - LeetCode 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 Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all cu..

197. Rising Temperature https://leetcode.com/problems/rising-temperature/ Rising Temperature - LeetCode 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 Write an SQL query to find all dates' id with higher temperature compared to its previous dates (yesterday). Return the result table in any..

185. Department Top Three Salaries https://leetcode.com/problems/department-top-three-salaries/ Department Top Three Salaries - LeetCode 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 The Employee table holds all employees. Every employee has an Id, and there is also a column for the depar..

184. Department Highest Salary https://leetcode.com/problems/department-highest-salary/ Department Highest Salary - LeetCode 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 The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the departm..

180. Consecutive Numbers https://leetcode.com/problems/consecutive-numbers/ Consecutive Numbers - LeetCode 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 Write a SQL query to find all numbers that appear at least three times consecutively. -- 윈도우함수로 풀기 SELECT DISTINCT l.Num AS ConsecutiveN..

196. Delete Duplicate Emails https://leetcode.com/problems/delete-duplicate-emails/ Delete Duplicate Emails - LeetCode 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 Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its sma..

627. Swap Salary https://leetcode.com/problems/swap-salary/ Swap Salary - LeetCode 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 Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice versa) with a..

181. Employees Earning More Than Their Managers https://leetcode.com/problems/employees-earning-more-than-their-managers/ Employees Earning More Than Their Managers - LeetCode 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 The Employee table holds all employees including their managers. Ev..