LeetCode SQL as many as I can complete

Checkout my other repositories for more LeetCode Lists and problem solutions

Name		Name	Last commit message	Last commit date
Latest commit History 210 Commits
00175-combine-two-tables.sql		00175-combine-two-tables.sql
00176-second-highest-salary.sql		00176-second-highest-salary.sql
00177-nth-highest-salary.sql		00177-nth-highest-salary.sql
00178-rank-scores.sql		00178-rank-scores.sql
00180-consecutive-numbers.sql		00180-consecutive-numbers.sql
00181-employees-earning-more-than-their-managers.sql		00181-employees-earning-more-than-their-managers.sql
00182-duplicate-emails.sql		00182-duplicate-emails.sql
00183-customers-who-never-order.sql		00183-customers-who-never-order.sql
00184-department-highest-salary.sql		00184-department-highest-salary.sql
00185-department-top-three-salaries.sql		00185-department-top-three-salaries.sql
00196-delete-duplicate-emails.sql		00196-delete-duplicate-emails.sql
00197-rising-temperature.sql		00197-rising-temperature.sql
00262-trips-and-users.sql		00262-trips-and-users.sql
00511-game-play-analysis-i.sql		00511-game-play-analysis-i.sql
00512-game-play-analysis-ii.sql		00512-game-play-analysis-ii.sql
00534-game-play-analysis-iii.sql		00534-game-play-analysis-iii.sql
00550-game-play-analysis-iv.sql		00550-game-play-analysis-iv.sql
00569-median-employee-salary.sql		00569-median-employee-salary.sql
00570-managers-with-at-least-5-direct-reports.sql		00570-managers-with-at-least-5-direct-reports.sql
00571-find-median-given-frequency-of-numbers.sql		00571-find-median-given-frequency-of-numbers.sql
00574-winning-candidate.sql		00574-winning-candidate.sql
00577-employee-bonus.sql		00577-employee-bonus.sql
00578-get-highest-answer-rate-question.sql		00578-get-highest-answer-rate-question.sql
00579-find-cumulative-salary-of-an-employee.sql		00579-find-cumulative-salary-of-an-employee.sql
00580-count-student-number-in-departments.sql		00580-count-student-number-in-departments.sql
00584-find-customer-referee.sql		00584-find-customer-referee.sql
00585-investments-in-2016.sql		00585-investments-in-2016.sql
00586-customer-placing-the-largest-number-of-orders.sql		00586-customer-placing-the-largest-number-of-orders.sql
00595-big-countries.sql		00595-big-countries.sql
00596-classes-more-than-5-students.sql		00596-classes-more-than-5-students.sql
00597-friend-requests-i-overall-acceptance-rate.sql		00597-friend-requests-i-overall-acceptance-rate.sql
00601-human-traffic-of-stadium.sql		00601-human-traffic-of-stadium.sql
00602-friend-requests-ii-who-has-the-most-friends.sql		00602-friend-requests-ii-who-has-the-most-friends.sql
00603-consecutive-available-seats.sql		00603-consecutive-available-seats.sql
00607-sales-person.sql		00607-sales-person.sql
00608-tree-node.sql		00608-tree-node.sql
00610-triangle-judgement.sql		00610-triangle-judgement.sql
00612-shortest-distance-in-a-plane.sql		00612-shortest-distance-in-a-plane.sql
00613-shortest-distance-in-a-line.sql		00613-shortest-distance-in-a-line.sql
00614-second-degree-follower.sql		00614-second-degree-follower.sql
00615-average-salary-departments-vs-company.sql		00615-average-salary-departments-vs-company.sql
00618-students-reported-by-geography.sql		00618-students-reported-by-geography.sql
00619-biggest-single-number.sql		00619-biggest-single-number.sql
00620-not-boring-movies.sql		00620-not-boring-movies.sql
00626-exchange-seats.sql		00626-exchange-seats.sql
00627-swap-salary.sql		00627-swap-salary.sql
01045-customers-who-bought-all-products.sql		01045-customers-who-bought-all-products.sql
01050-actors-and-director-who-cooperated-at-least-three-times.sql		01050-actors-and-director-who-cooperated-at-least-three-times.sql
01068-product-sales-analysis-i.sql		01068-product-sales-analysis-i.sql
01069-prooduct-sales-analysis-ii.sql		01069-prooduct-sales-analysis-ii.sql
01070-product-sales-analysis-iii.sql		01070-product-sales-analysis-iii.sql
01075-project-employees-i.sql		01075-project-employees-i.sql
01076-project-employees-ii.sql		01076-project-employees-ii.sql
01077-project-employees-iii.sql		01077-project-employees-iii.sql
01082-sales-analysis-i.sql		01082-sales-analysis-i.sql
01083-sales-analysis-ii.sql		01083-sales-analysis-ii.sql
01084-sales-analysis-iii.sql		01084-sales-analysis-iii.sql
01097-game-play-analysis-v.sql		01097-game-play-analysis-v.sql
01098-unpopular-books.sql		01098-unpopular-books.sql
01107-new-users-daily-count.sql		01107-new-users-daily-count.sql
01112-highest-grade-for-each-student.sql		01112-highest-grade-for-each-student.sql
01113-reported-posts.sql		01113-reported-posts.sql
01126-active-businesses.sql		01126-active-businesses.sql
01127-user-purchase-platform.sql		01127-user-purchase-platform.sql
01132-reported-posts-ii.sql		01132-reported-posts-ii.sql
01141-user-activity-for-the-past-30-days-i.sql		01141-user-activity-for-the-past-30-days-i.sql
01142-user-activity-for-the-past-30-days-ii.sql		01142-user-activity-for-the-past-30-days-ii.sql
01148-article-views-i.sql		01148-article-views-i.sql
01149-article-views-ii.sql		01149-article-views-ii.sql
01158-market-analysis-i.sql		01158-market-analysis-i.sql
01159-market-analysis-ii.sql		01159-market-analysis-ii.sql
01164-product-price-at-a-given-date.sql		01164-product-price-at-a-given-date.sql
01173-immediate-food-delivery-i.sql		01173-immediate-food-delivery-i.sql
01174-immediate-food-delivery-ii.sql		01174-immediate-food-delivery-ii.sql
01179-reformat-department-table.sql		01179-reformat-department-table.sql
01193-monthly-transactions-i.sql		01193-monthly-transactions-i.sql
01194-tournament-winners.sql		01194-tournament-winners.sql
01204-last-person-to-fit-in-the-bus.sql		01204-last-person-to-fit-in-the-bus.sql
01205-monthly-tractions-ii.sql		01205-monthly-tractions-ii.sql
01211-queries-quality-and-percentage.sql		01211-queries-quality-and-percentage.sql
01212-teams-scores-in-football-tournamant.sql		01212-teams-scores-in-football-tournamant.sql
01225-report-contiguous-dates.sql		01225-report-contiguous-dates.sql
01241-number-of-comments-per-post.sql		01241-number-of-comments-per-post.sql
01251-average-selling-price.sql		01251-average-selling-price.sql
01264-page-recommendations.sql		01264-page-recommendations.sql
01270-all-people-report-to-the-given-manager.sql		01270-all-people-report-to-the-given-manager.sql
01280-students-and-examinations.sql		01280-students-and-examinations.sql
01285-find-the-start-and-end-number-of-continuous-ranges.sql		01285-find-the-start-and-end-number-of-continuous-ranges.sql
01294-weather-type-in-each-country.sql		01294-weather-type-in-each-country.sql
01303-find-the-team-size.sql		01303-find-the-team-size.sql
01308-running-total-for-different-genders.sql		01308-running-total-for-different-genders.sql
01321-restaurant-growth.sql		01321-restaurant-growth.sql
01322-ads-performance.sql		01322-ads-performance.sql
01327-list-the-products-ordered-in-a-period.sql		01327-list-the-products-ordered-in-a-period.sql
01336-number-of-transactions-per-visit.sql		01336-number-of-transactions-per-visit.sql
01341-movie-rating.sql		01341-movie-rating.sql
01350-students-with-invalid-departments.sql		01350-students-with-invalid-departments.sql
01355-activity-participans.sql		01355-activity-participans.sql
01364-number-of-trusted-contacts-of-a-customer.sql		01364-number-of-trusted-contacts-of-a-customer.sql
01369-get-the-second-most-recent-ctivity.sql		01369-get-the-second-most-recent-ctivity.sql

leetlab11/SQL-ALL

Folders and files

Latest commit

History