SQL 50
SELECT
- 1757. Recyclable and Low Fat Products
- 584. Find Customer Referee
- 595. Big Countries
- 1148. Article Views I
- 1683. Invalid Tweets
Basic Joins
- 1378. Replace Employee ID With The Unique Identifier
- 1068. Product Sales Analysis I
- 1581. Customer Who Visited but Did Not Make Any Transactions
- 197. Rising Temperature
- 1661. Average Time of Process per Machine
- 577. Employee Bonus
- 1280. Students and Examinations
- 570. Managers with at Least 5 Direct Reports
- 1934. Confirmation Rate
Basic Aggregate Functions
- 620. Not Boring Movies
- 1251. Average Selling Price
- 1075. Project Employees I
- 1633. Percentage of Users Attended a Contest
- 1211. Queries Quality and Percentage
- 1193. Monthly Transactions I
- 1174. Immediate Food Delivery II
- 550. Game Play Analysis IV
Sorting and Grouping
- 2356. Number of Unique Subjects Taught by Each Teacher
- 1141. User Activity for the Past 30 Days I
- 1070. Product Sales Analysis III
- 596. Classes More Than 5 Students
- 1729. Find Followers Count
- 619. Biggest Single Number
- 1045. Customers Who Bought All Products
Advanced Select and Joins
- 1731. The Number of Employees Which Report to Each Employee
- 1789. Primary Department for Each Employee
- 610. Triangle Judgement
- 180. Consecutive Numbers
- 1164. Product Price at a Given Date
- 1204. Last Person to Fit in the Bus
- 1907. Count Salary Categories
Subqueries
- 1978. Employees Whose Manager Left the Company
- 626. Exchange Seats
- 1341. Movie Rating
- 1321. Restaurant Growth
- 602. Friend Requests II: Who Has the Most Friends
- 585. Investments in 2016
- 185. Department Top Three Salaries