This Repository contains SQL 50 Question with video solution of Leetcode If you are a beginner and looking to improve SQL or an experienced developer interested in exploring different concepts, this collection has something for you.
| Lectures | Video Link | LeetCode Question | Solution |
|---|---|---|---|
| 1) 1757. Recyclable and Low Fat Products |  |
 |
 |
| 2) 584. Find Customer Referee | |
|
|
| 3) 595. Big Countries | |
|
|
| 4) 1148. Article Views I | |
|
|
| 5) 1683. Invalid Tweets | |
|
|
| 6) 1378. Replace Employee ID With The Unique Identifier | |
|
|
| 7) 1068. Product Sales Analysis I | |
|
|
| 8) 1581. Customer Who Visited but Did Not Make Any Transactions | |
|
|
| 9) 197. Rising Temperature | |
|
|
| 10) 1661. Average Time of Process per Machine | |
|
|
| 11) 577. Employee Bonus | |
|
|
| 12) 1280. Students and Examinations | |
|
|
| 13) 570. Managers with at Least 5 Direct Reports | |
|
|
| 14) 1934. Confirmation Rate | |
|
|
| 15) 620. Not Boring Movies | |
|
|
| 16) 1251. Average Selling Price | |
|
|
| 17) 1075. Project Employees I | |
|
|
| 18) 1633. Percentage of Users Attended a Contest | |
|
|
| 19) 1211. Queries Quality and Percentage | |
|
|
| 20) 1193. Monthly Transactions I | |
|
|
| 21) 1174. Immediate Food Delivery II | |
|
|
| 22) 550. Game Play Analysis IV | |
|
|
| 23) 2356. Number of Unique Subjects Taught by Each Teacher | |
|
|
| 24) 1141. User Activity for the Past 30 Days I | |
|
|
| 25) 1070. Product Sales Analysis III | |
|
|
| 26) 596. Classes More Than 5 Students | |
|
|
| 27) 1729. Find Followers Count | |
|
|
| 28) 619. Biggest Single Number | |
|
|
| 29) 1045. Customers Who Bought All Products | |
|
|
| 30) 1731. The Number of Employees Which Report to Each Employee | |
|
|
| 31) 1789. Primary Department for Each Employee | |
|
|
| 32) 610. Triangle Judgement | |
|
|
| 33) 180. Consecutive Numbers | |
|
|
| 34) 1164. Product Price at a Given Date | |
|
|
| 35) 1204. Last Person to Fit in the Bus | |
|
|
| 36) 1907. Count Salary Categories | |
|
|
| 37) 1978. Employees Whose Manager Left the Company | |
|
|
| 38) 626. Exchange Seats | |
|
|
| 39) 1341. Movie Rating | |
|
|
| 40) 1321. Restaurant Growth | |
|
|
| 41) 602. Friend Requests II: Who Has the Most Friends | |
|
|
| 42) 585. Investments in 2016 | |
|
|
| 43) 185. Department Top Three Salaries | |
|
|
| 44) 1667. Fix Names in a Table | |
|
|
| 45) 1527. Patients With a Condition | |
|
|
| 46) 196. Delete Duplicate Emails | |
|
|
| 47) 176. Second Highest Salary | |
|
|
| 48) 1484. Group Sold Products By The Date | |
|
|
| 49) 1327. List the Products Ordered in a Period | |
|
|
| 50) 1517. Find Users With Valid E-Mails | |
|
|
