Skip to content

debabratabar/leetcode-sql-50

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
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
 
 

Repository files navigation

leetcode-sql-50

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

Leetcode_sql_50_study_plan

I am using Postgresql for the solution

About

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

leetcode.com/studyplan/top-sql-50/

Topics

sql leetcode leetco

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

 
 
 

Contributors

Languages