Leetcode

Top SQL 50

Select

1. Recyclable and Low Fat Products
2. Find Customer Referee
3. Big Countries
4. Article Views I
5. Invalid Tweets

Basic Joins

6. Replace Employee ID With The Unique Identifier
7. Product Sales Analysis I
8. Customer Who Visited But Did Not Make Any Transactions
9. Rising Temperature
10. Average Time of Process Per Machine
11. Employee Bonus
12. Students and Examinations
13. Managers with at Least 5 Direct Reports
14. Confirmation Rate

Basic Aggregate Functions

15. Not Boring Movies
16. Average Selling Price
17. Project Employees I
18. Percentage of Users Attended a Contest
19. Queries Quality and Percentage
20. Monthly Transactions I
21. Immediate Food Delivery II
22. Game Play Analysis IV

Sorting and Grouping

23. Number of Unique Subjects Taught by Each Teacher
24. User Activity for the Past 30 Days I
25. Product Sales Analysis II
26. Classes More Than 5 Students
27. Find Followers Count
28. Biggest Single Number
29. Customer Who Bought Products

Advanced Select and Joins

30. The Number of Employees Which Report to Each Employee
31. Primary Department for Each Employee

Subqueries

Advanced String Functions / Regex / Clause