arfin-parween/SQL-50-Leetcode-Public

NotificationsYou must be signed in to change notification settings
Fork25
Star34

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.

www.youtube.com/playlist?list=PL23dd-8zssJC0n4--rrdmbD4mROCcg5Uw

License

MIT license

34 stars 25 forks Branches Tags Activity

Star

Notifications

You must be signed in to change notification settings

Branches Tags

Folders and files

Name		Name	Last commit message	Last commit date
Latest commit History 176 Commits
0176-second-highest-salary		0176-second-highest-salary
0180-consecutive-numbers		0180-consecutive-numbers
0185-department-top-three-salaries		0185-department-top-three-salaries
0196-delete-duplicate-emails		0196-delete-duplicate-emails
0197-rising-temperature		0197-rising-temperature
0550-game-play-analysis-iv		0550-game-play-analysis-iv
0570-managers-with-at-least-5-direct-reports		0570-managers-with-at-least-5-direct-reports
0577-employee-bonus		0577-employee-bonus
0584-find-customer-referee		0584-find-customer-referee
0585-investments-in-2016		0585-investments-in-2016
0595-big-countries		0595-big-countries
0596-classes-more-than-5-students		0596-classes-more-than-5-students
0602-friend-requests-ii-who-has-the-most-friends		0602-friend-requests-ii-who-has-the-most-friends
0610-triangle-judgement		0610-triangle-judgement
0619-biggest-single-number		0619-biggest-single-number
0620-not-boring-movies		0620-not-boring-movies
0626-exchange-seats		0626-exchange-seats
1045-customers-who-bought-all-products		1045-customers-who-bought-all-products
1068-product-sales-analysis-i		1068-product-sales-analysis-i
1070-product-sales-analysis-iii		1070-product-sales-analysis-iii
1075-project-employees-i		1075-project-employees-i
1141-user-activity-for-the-past-30-days-i		1141-user-activity-for-the-past-30-days-i
1148-article-views-i		1148-article-views-i
1164-product-price-at-a-given-date		1164-product-price-at-a-given-date
1174-immediate-food-delivery-ii		1174-immediate-food-delivery-ii
1193-monthly-transactions-i		1193-monthly-transactions-i
1204-last-person-to-fit-in-the-bus		1204-last-person-to-fit-in-the-bus
1211-queries-quality-and-percentage		1211-queries-quality-and-percentage
1251-average-selling-price		1251-average-selling-price
1280-students-and-examinations		1280-students-and-examinations
1321-restaurant-growth		1321-restaurant-growth
1327-list-the-products-ordered-in-a-period		1327-list-the-products-ordered-in-a-period
1341-movie-rating		1341-movie-rating
1378-replace-employee-id-with-the-unique-identifier		1378-replace-employee-id-with-the-unique-identifier
1484-group-sold-products-by-the-date		1484-group-sold-products-by-the-date
1517-find-users-with-valid-e-mails		1517-find-users-with-valid-e-mails
1527-patients-with-a-condition		1527-patients-with-a-condition
1581-customer-who-visited-but-did-not-make-any-transactions		1581-customer-who-visited-but-did-not-make-any-transactions
1633-percentage-of-users-attended-a-contest		1633-percentage-of-users-attended-a-contest
1661-average-time-of-process-per-machine		1661-average-time-of-process-per-machine
1667-fix-names-in-a-table		1667-fix-names-in-a-table
1683-invalid-tweets		1683-invalid-tweets
1729-find-followers-count		1729-find-followers-count
1731-the-number-of-employees-which-report-to-each-employee		1731-the-number-of-employees-which-report-to-each-employee
1757-recyclable-and-low-fat-products		1757-recyclable-and-low-fat-products
1789-primary-department-for-each-employee		1789-primary-department-for-each-employee
1907-count-salary-categories		1907-count-salary-categories
1934-confirmation-rate		1934-confirmation-rate
1978-employees-whose-manager-left-the-company		1978-employees-whose-manager-left-the-company
2356-number-of-unique-subjects-taught-by-each-teacher		2356-number-of-unique-subjects-taught-by-each-teacher
LICENSE		LICENSE
README.md		README.md

Repository files navigation

SQL 50 Leetcode

Hey There!

This Repository contains SQL 50 Question with video solution of LeetcodeIf you are a beginner and looking to improve SQL or an experienced developer interested in exploring different concepts, this collection has something for you.

Please to my Youtube Channel

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