Some solved problems from LeetCode on SQL.
Profile on LeetCode: fartem.
| Name | Link to LeetCode | Link to solution |
|---|---|---|
| 175. Combine Two Tables | Link | Link |
| 181. Employees Earning More Than Their Managers | Link | Link |
| 182. Duplicate Emails | Link | Link |
| 183. Customers Who Never Order | Link | Link |
| 196. Delete Duplicate Emails | Link | Link |
| 511. Game Play Analysis I | Link | Link |
| 584. Find Customer Referee | Link | Link |
| 586. Customer Placing the Largest Number of Orders | Link | Link |
| 595. Big Countries | Link | Link |
| 596. Classes More Than 5 Students | Link | Link |
| 607. Sales Person | Link | Link |
| 620. Not Boring Movies | Link | Link |
| 627. Swap Salary | Link | Link |
| 1050. Actors and Directors Who Cooperated At Least Three Times | Link | Link |
| 1141. User Activity for the Past 30 Days I | Link | Link |
| 1148. Article Views I | Link | Link |
| 1179. Reformat Department Table | Link | Link |
| 1407. Top Travellers | Link | Link |
| 1484. Group Sold Products By The Date | Link | Link |
| 1527. Patients With a Condition | Link | Link |
| 1581. Customer Who Visited but Did Not Make Any Transactions | Link | Link |
| 1587. Bank Account Summary II | Link | Link |
| 1667. Fix Names in a Table | Link | Link |
| 1693. Daily Leads and Partners | Link | Link |
| 1729. Find Followers Count | Link | Link |
| 1741. Find Total Time Spent by Each Employee | Link | Link |
| 1757. Recyclable and Low Fat Products | Link | Link |
| 1795. Rearrange Products Table | Link | Link |
| 1873. Calculate Special Bonus | Link | Link |
| 1890. The Latest Login in 2020 | Link | Link |