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 |