LeetCode
1.[SQL] LeetCode > 196. Delete Duplicate Emails
Link1) Write an SQL query to delete all the duplicate emails, keeping only one unique email with the smallest id.2) Note that you are supposed to writ
2.[SQL] LeetCode > 184. Department Highest Salary
184. Department Highest Salary Link Table: Employee id, name, salary, departmentID Table: Department id, name Write an SQL query to find employees
3.[SQL] LeetCode > 1484. Group Sold Products By The Date
LinkWrite an SQL query to find for each date the number of different products sold and their names.The sold products names for each date should be sor
4.[SQL] LeetCode > 197. Rising Temperature (Self Join)
LinkWrite an SQL query to find all dates' Id with higher temperatures compared to its previous dates (yesterday).Return the result table in any order.
5.[SQL] LeetCode > 181. Employees Earning More Than Their Managers (Self Join)
LinkWrite an SQL query to find the employees who earn more than their managers.Return the result table in any order.The query result format is in the