My Picks - SQL

Join

• 184. Department Highest Salary
• 550. Game Play Analysis IV
• 1158. Market Analysis I
• 1251. Average Selling Price
• 1280. Students and Examinations
• 1407. Top Travellers
• 1661. Average Time of Process per Machine

Grouping

• 1174. Immediate Food Delivery II
• 1789. Primary Department for Each Employee

LIMIT and OFFSET

• 177. Nth Highest Salary
• 602. Friend Requests II: Who Has the Most Friends

Subquery

A very good example for Subquery. Especially for EXISTS and NOT EXISTS:

• 183. Customers Who Never Order
• 1084. Sales Analysis III
• 1978. Employees Whose Manager Left the Company

These are very difficult but worth to do:

• 176. Second Highest Salary
• 585. Investments in 2016
• 185. Department Top Three Salaries

Advanced Functions

• 178. Rank Scores
• 1193. Monthly Transactions I
• 1204. Last Person to Fit in the Bus
• 1321. Restaurant Growth
• 1484. Group Sold Products By The Date
• 1934. Confirmation Rate

Some "Creativity" and "Tricks"

• 180. Consecutive Numbers
• 262. Trips and Users
• 601. Human Traffic of Stadium
• 608. Tree Node
• 626. Exchange Seats
• 627. Swap Salary
• 1164. Product Price at a Given Date
• 1341. Movie Rating
• 1965. Employees With Missing Information