leetcode-sql-50

this repo has solution for leetcode sql top 50 questions from sql study plan

Leetcode_sql_50_study_plan

Name		Name	Last commit message	Last commit date
1045-customer-all-products.sql		1045-customer-all-products.sql
1068-product-sales-1.sql		1068-product-sales-1.sql
1070-product-sales-analysis-3.sql		1070-product-sales-analysis-3.sql
1075-project-emp-1.sql		1075-project-emp-1.sql
1141-active-user-30-days.sql		1141-active-user-30-days.sql
1148-Article-views-1.sql		1148-Article-views-1.sql
1164-product-price-in-a-date.sql		1164-product-price-in-a-date.sql
1174-immediate-food-delivery.sql		1174-immediate-food-delivery.sql
1179-Reformat-Department-Table.sql		1179-Reformat-Department-Table.sql
1193-monthly-transaction-1.sql		1193-monthly-transaction-1.sql
1204-last-person-to-fit.sql		1204-last-person-to-fit.sql
1211-query-quality.sql		1211-query-quality.sql
1251-avg_selling-price.sql		1251-avg_selling-price.sql
1280-student-exam.sql		1280-student-exam.sql
1321-restaurant-growth.sql		1321-restaurant-growth.sql
1327-list-prod-in-per.sql		1327-list-prod-in-per.sql
1341-movie-rating.sql		1341-movie-rating.sql
1378-employee-unique-id.sql		1378-employee-unique-id.sql
1484-group-by-sold-prod.sql		1484-group-by-sold-prod.sql
1517-valid-email.sql		1517-valid-email.sql
1527-patient-with-cond.sql		1527-patient-with-cond.sql
1581-cust-without-trans.sql		1581-cust-without-trans.sql
1633-prec-of-attended.sql		1633-prec-of-attended.sql
1661-avg-process-time.sql		1661-avg-process-time.sql
1667-fix-names.sql		1667-fix-names.sql
1683-invalid-tweets.sql		1683-invalid-tweets.sql
1729-follower-count.sql		1729-follower-count.sql
1731-emp-rprt.sql		1731-emp-rprt.sql
1757-recyclable-low-fat-prod.sql		1757-recyclable-low-fat-prod.sql
176-second-highest-sal.sql		176-second-highest-sal.sql
177-Nth-Highest-Salary.sql		177-Nth-Highest-Salary.sql
178-Rank-Scores.sql		178-Rank-Scores.sql
1789-prim-dept.sql		1789-prim-dept.sql
180-consecutive-numbers.sql		180-consecutive-numbers.sql
181-Employees-Earning-More-Than-Their-Managers.sql		181-Employees-Earning-More-Than-Their-Managers.sql
184-Department-Highest-Salary.sql		184-Department-Highest-Salary.sql
185-dept-top-3-sal.sql		185-dept-top-3-sal.sql
1907-count-salary-catg.sql		1907-count-salary-catg.sql
196-delete-dups-email.sql		196-delete-dups-email.sql
197-rising-temp.sql		197-rising-temp.sql
1978-emp-manager-left.sql		1978-emp-manager-left.sql
1983-confirmation-rate.sql		1983-confirmation-rate.sql
2356-teacher-unique-subj.sql		2356-teacher-unique-subj.sql
262-Trips-and-Users.sql		262-Trips-and-Users.sql
3220-Odd-and-Even-Transactions.sql		3220-Odd-and-Even-Transactions.sql
3374-First-Letter-Capitalization-II.sql		3374-First-Letter-Capitalization-II.sql
3421-Find-Students-Who-Improved.sql		3421-Find-Students-Who-Improved.sql
3436-Find-Valid-Emails.sql		3436-Find-Valid-Emails.sql
3465-Find-Products-with-Valid-Serial-Numbers.sql		3465-Find-Products-with-Valid-Serial-Numbers.sql
3475-DNA-Pattern-Recognition.sql		3475-DNA-Pattern-Recognition.sql
3497-Analyze-Subscription-Conversion.sql		3497-Analyze-Subscription-Conversion.sql
3521-Find-Product-Recommendation-Pairs.sql		3521-Find-Product-Recommendation-Pairs.sql
3554-Find-Category-Recommendation-Pairs.sql		3554-Find-Category-Recommendation-Pairs.sql
3564-Seasonal-Sales-Analysis.sql		3564-Seasonal-Sales-Analysis.sql
3570-Find-Books-with-No-Available-Copies.sql		3570-Find-Books-with-No-Available-Copies.sql
3580-Find-Consistently-Improving-Employees.sql		3580-Find-Consistently-Improving-Employees.sql
3586-Find-COVID-Recovery-Patients.sql		3586-Find-COVID-Recovery-Patients.sql
3601-Find-Drivers-with-Improved-Fuel-Efficiency.sql		3601-Find-Drivers-with-Improved-Fuel-Efficiency.sql
550-game-play-analysis-iv.sql		550-game-play-analysis-iv.sql
570-managers-with-5-direct-reports.sql		570-managers-with-5-direct-reports.sql
577-emp-bonus.sql		577-emp-bonus.sql
584-customer-referee.sql		584-customer-referee.sql
585-invtmt-2016.sql		585-invtmt-2016.sql
595-big-countries.sql		595-big-countries.sql
596-class-with-5-stu.sql		596-class-with-5-stu.sql
601-Human-Traffic-of-Stadium.sql		601-Human-Traffic-of-Stadium.sql
602-friend-req-2.sql		602-friend-req-2.sql
610-triangle-judgement.sql		610-triangle-judgement.sql
619-biggest-single-num.sql		619-biggest-single-num.sql
620-not-boring-movies.sql		620-not-boring-movies.sql
626-exchange-seats.sql		626-exchange-seats.sql
README.md		README.md

Navigation Menu

Repository files navigation

leetcode-sql-50

this repo has solution for leetcode sql top 50 questions from sql study plan

I am using Postgresql for the solution

About

Releases

Packages

Contributors

Languages

Latest commit

History

Folders and files

Repository files navigation

leetcode-sql-50

this repo has solution for leetcode sql top 50 questions from sql study plan

I am using Postgresql for the solution

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages