Solutions of SQL exercises form Leet Code.
| Problem ID | Problem Name | Link | My solution |
|---|---|---|---|
| 610 | Triangle Judgement | Link | My solution |
| 619 | Biggest Single Number | Link | My solution |
| 620 | Not Boring Movies | Link | My solution |
| 1084 | Sales Analysis III | Link | My solution |
| 1068 | Product Sales Analysis I | Link | My solution |
| 1141 | User Activity for the Past 30 Days I | Link | My solution |
| 1211 | Queries Quality and Percentage | Link | My solution |
| 1517 | Find Users With Valid E-Mails | Link | My solution |
| 1633 | Percentage of Users Attended a Contest | Link | My solution |
| 1148 | Article Views I | Link | My solution |
| 1173 | Immediate Food Delivery I | Link | My solution |
| 1179 | Reformat Department Table | Link | My solution |
| 1251 | Average Selling Price | Link | My solution |
| 1378 | Replace Employee ID With The Unique Identifier | Link | My solution |
| 1873 | Calculate Special Bonus | Link | My solution |
| 1280 | Students and Examinations | Link | My solution |
| 1407 | Top Travellers | Link | My solution |
| 1757 | Recyclable and Low Fat Products | Link | My solution |
| 1527 | Patients With a Condition | Link | My solution |
| 1327 | List The Products Ordered In A Period | Link | My solution |
| 1581 | Customer Who Visited But Did Not Make Any Transactions | Link | My solution |
| 1587 | Bank Account Summary Ii | Link | My solution |
| 1661 | Average Time Of Process Per Machine | Link | My solution |
| 1683 | Invalid Tweets | Link | My solution |
| 1667 | Fix Names In A Table | Link | My solution |
| 1693 | Daily Leads And Partners | Link | My solution |
| 1729 | Find Followers Count | Link | My solution |
| 1731 | The Number Of Employees Which Report To Each Employee | Link | My solution |
| 182 | Duplicate Emails | Link | My solution |
| 182 | Duplicate Emails | Link | My solution |
| 1741 | Find Total Time Spent By Each Employee | Link | My solution |
| 1741 | Find Total Time Spent By Each Employee | Link | My solution |
| 182 | Duplicate Emails | Link | My solution |
| 182 | Duplicate Emails | Link | My solution |
| 1741 | Find Total Time Spent By Each Employee | Link | My solution |
| 1789 | Primary Department For Each Employee | Link | My solution |
| 1795 | Rearrange Products Table | Link | My solution |
| 1890 | The Latest Login In 2020 | Link | My solution |
| 2356 | Number Of Unique Subjects Taught By Each Teacher | Link | My solution |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent