This repository contains my solutions to the problems in SQL 50 Study Plan of LeetCode.
| # | Title | Solution | Subtopic | Difficulty |
|---|---|---|---|---|
| 1757 | Recyclable and Low Fat Products | MySQL | Select | Easy |
| 584 | Find Customer Referee | MySQL | Select | Easy |
| 595 | Big Countries | MySQL | Select | Easy |
| 1148 | Article Views I | MySQL | Select | Easy |
| 1683 | Invalid Tweets | MySQL | Select | Easy |
| 1378 | Replace Employee ID With The Unique Identifier | MySQL | Joins | Easy |
| 1068 | Product Sales Analysis I | MySQL | Joins | Easy |
| 1581 | Customer Who Visited but Did Not Make Any Transactions | MySQL | Joins | Easy |
| 197 | Rising Temperature | MySQL | Joins | Easy |
| 1661 | Average Time of Process per Machine | MySQL | Joins | Easy |
| 577 | Employee Bonus | MySQL | Joins | Easy |
| 1280 | Students and Examinations | MySQL | Joins | Easy |
| 570 | Managers with at Least 5 Direct Reports | MySQL | Joins | Medium |
| 1934 | Confirmation Rate | MySQL | Joins | Medium |
| 620 | Not Boring Movies | MySQL | Aggregate Functions | Easy |
| 1251 | Average Selling Price | MySQL | Aggregate Functions | Easy |
| 1075 | Project Employees I | MySQL | Aggregate Functions | Easy |
| 1633 | Percentage of Users Attended a Contest | MySQL | Aggregate Functions | Easy |
| 1211 | Queries Quality and Percentage | MySQL | Aggregate Functions | Easy |
| 1193 | Monthly Transactions I | MySQL | Aggregate Functions | Medium |
| 1174 | Immediate Food Delivery II | MySQL | Aggregate Functions | Medium |
| 550 | Game Play Analysis IV | MySQL | Aggregate Functions | Medium |
| 2356 | Number of Unique Subjects Taught by Each Teacher | MySQL | Sorting and Grouping | Easy |
| 1141 | User Activity for the Past 30 Days I | MySQL | Sorting and Grouping | Easy |
| 1070 | Product Sales Analysis III | MySQL | Sorting and Grouping | Medium |
| 596 | Classes More Than 5 Students | MySQL | Sorting and Grouping | Easy |
| 1729 | Find Followers Count | MySQL | Sorting and Grouping | Easy |
| 619 | Biggest Single Number | MySQL | Sorting and Grouping | Easy |
| 1045 | Customers Who Bought All Products | MySQL | Sorting and Grouping | Medium |
| 1731 | The Number of Employees Which Report to Each Employee | MySQL | Advanced Select and Joins | Easy |
| 1789 | Primary Department for Each Employee | MySQL | Advanced Select and Joins | Easy |
| 610 | Triangle Judgement | MySQL | Advanced Select and Joins | Easy |
| 180 | Consecutive Numbers | MySQL | Advanced Select and Joins | Medium |
| 1164 | Product Price at a Given Date | MySQL | Advanced Select and Joins | Medium |
| 1204 | Last Person to Fit in the Bus | MySQL | Advanced Select and Joins | Medium |
| 1907 | Count Salary Categories | MySQL | Advanced Select and Joins | Medium |
| 1978 | Employees Whose Manager Left the Company | MySQL | Subqueries | Easy |
| 626 | Exchange Seats | MySQL | Subqueries | Medium |
| 1341 | Movie Rating | MySQL | Subqueries | Medium |
| 1321 | Restaurant Growth | MySQL | Subqueries | Medium |
| 602 | Friend Requests II: Who Has the Most Friends | MySQL | Subqueries | Medium |
| 585 | Investments in 2016 | MySQL | Subqueries | Medium |
| 185 | Department Top Three Salaries | MySQL | Subqueries | Hard |
| 1667 | Fix Names in a Table | MySQL | Advanced String Functions / Regex / Clause | Easy |
| 1527 | Patients With a Condition | MySQL | Advanced String Functions / Regex / Clause | Easy |
| 196 | Delete Duplicate Emails | MySQL | Advanced String Functions / Regex / Clause | Easy |
| 176 | Second Highest Salary | MySQL | Advanced String Functions / Regex / Clause | Medium |
| 1484 | Group Sold Products By The Date | MySQL | Advanced String Functions / Regex / Clause | Easy |
| 1327 | List the Products Ordered in a Period | MySQL | Advanced String Functions / Regex / Clause | Easy |
| 1517 | Find Users With Valid E-Mails | MySQL | Advanced String Functions / Regex / Clause | Easy |