Skip to content

leetlab11/Advanced-SQL-50

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

95 Commits
01-01821-find-customers-with-positive-revenue-this-year.sql
01-01821-find-customers-with-positive-revenue-this-year.sql
 
 
02-00183-customers-who-never-order.sql
02-00183-customers-who-never-order.sql
 
 
03-01873-calculate-special-bonus.sql
03-01873-calculate-special-bonus.sql
 
 
04-01398-customers-who-bought-products-A-and-B-but-not-C.sql
04-01398-customers-who-bought-products-A-and-B-but-not-C.sql
 
 
05-01112-highest-grade-for-each-student.sql
05-01112-highest-grade-for-each-student.sql
 
 
06-00175-combine-two-tables.sql
06-00175-combine-two-tables.sql
 
 
07-01607-sellers-with-no-sales.sql
07-01607-sellers-with-no-sales.sql
 
 
08-01407-top-travellers.sql
08-01407-top-travellers.sql
 
 
09-00607-sales-person.sql
09-00607-sales-person.sql
 
 
10-01440-evaluate-boolean-expression.sql
10-01440-evaluate-boolean-expression.sql
 
 
11-01212-teams-scores-in-football-tournamant.sql
11-01212-teams-scores-in-football-tournamant.sql
 
 
12-01890-the-latest-login-in-2020.sql
12-01890-the-latest-login-in-2020.sql
 
 
13-00511-game-play-analysis-i.sql
13-00511-game-play-analysis-i.sql
 
 
14-01571-warehouse-manager.sql
14-01571-warehouse-manager.sql
 
 
15-00586-customer-placing-the-largest-number-of-orders.sql
15-00586-customer-placing-the-largest-number-of-orders.sql
 
 
16-01741-find-total-time-spent-by-each-employee.sql
16-01741-find-total-time-spent-by-each-employee.sql
 
 
17-01173-immediate-food-delivery-i.sql
17-01173-immediate-food-delivery-i.sql
 
 
18-01445-apples-&-oranges.sql
18-01445-apples-&-oranges.sql
 
 
19-01699-number-of-calls-between-two-persons.sql
19-01699-number-of-calls-between-two-persons.sql
 
 
20-01587-bank-account-summary-ii.sql
20-01587-bank-account-summary-ii.sql
 
 
21-00182-duplicate-emails.sql
21-00182-duplicate-emails.sql
 
 
22-01050-actors-and-director-who-cooperated-at-least-three-times.sql
22-01050-actors-and-director-who-cooperated-at-least-three-times.sql
 
 
23-01511-customer_order-frequency.sql
23-01511-customer_order-frequency.sql
 
 
24-01693-daily_leads-and-partners.sql
24-01693-daily_leads-and-partners.sql
 
 
25-01495-friendly-movies-streamed-last-month.sql
25-01495-friendly-movies-streamed-last-month.sql
 
 
26-01501-countries-you-can-safely-invest-in.sql
26-01501-countries-you-can-safely-invest-in.sql
 
 
27-00603-consecutive-available-seats.sql
27-00603-consecutive-available-seats.sql
 
 
28-01795-rearrange-products-table.sql
28-01795-rearrange-products-table.sql
 
 
29-00613-shortest-distance-in-a-line.sql
29-00613-shortest-distance-in-a-line.sql
 
 
30-01965-employees-with-missing-information.sql
30-01965-employees-with-missing-information.sql
 
 
31-01264-page-recommendations.sql
31-01264-page-recommendations.sql
 
 
32-00608-tree-node.sql
32-00608-tree-node.sql
 
 
33-00534-game-play-analysis-iii.sql
33-00534-game-play-analysis-iii.sql
 
 
34-01783-grand-slam-titles.sql
34-01783-grand-slam-titles.sql
 
 
35-01747-leetflex-banned-accounts.sql
35-01747-leetflex-banned-accounts.sql
 
 
36-01350-students-with-invalid-departments.sql
36-01350-students-with-invalid-departments.sql
 
 
37-01303-find-the-team-size.sql
37-01303-find-the-team-size.sql
 
 
38-00512-game-play-analysis-ii.sql
38-00512-game-play-analysis-ii.sql
 
 
39-00184-department-highest-salary.sql
39-00184-department-highest-salary.sql
 
 
40-01549-the-most-recent-orders-for-each-product.sql
40-01549-the-most-recent-orders-for-each-product.sql
 
 
41-01532-the-most-recent-three-orders.sql
41-01532-the-most-recent-three-orders.sql
 
 
42-01831-maximum-transaction-each-day.sql
42-01831-maximum-transaction-each-day.sql
 
 
43-01077-project-employees-iii.sql
43-01077-project-employees-iii.sql
 
 
44-01285-find-the-start-and-end-number-of-continuous-ranges.sql
44-01285-find-the-start-and-end-number-of-continuous-ranges.sql
 
 
45-01596-the-most-frequently-ordered-products-for-each-customer.sql
45-01596-the-most-frequently-ordered-products-for-each-customer.sql
 
 
46-01709-biggest-window-between-visits.sql
46-01709-biggest-window-between-visits.sql
 
 
47-01270-all-people-report-to-the-given-manager.sql
47-01270-all-people-report-to-the-given-manager.sql
 
 
48-01412-find-the-quiet-students-in-all-exams.sql
48-01412-find-the-quiet-students-in-all-exams.sql
 
 
49-01767-find-the-subtasks-that-did-not-execute.sql
49-01767-find-the-subtasks-that-did-not-execute.sql
 
 
50-01225-report-contiguous-dates.sql
50-01225-report-contiguous-dates.sql
 
 
README.md
README.md
 
 

Repository files navigation

LeetCode Advanced SQL 50 list- 50/50 solved

Checkout my other repositories for more LeetCode Lists and problem solutions

About

LeetCode Premium Advanced SQL 50 List- Solved 50/50 problems

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

Topics

sql database leetcode leetcode-solutions leetcode-questions leetcode-practice leetcode-sql leetcode-database advanced-sql leetcode-problems-solutions leetcode-solution leetcode-problems leetcode-list leetcode-preparation leetcode-problem-set leetcode-premium leetcode-sql-50 leetcode-sql-solutions leetcode-advanced-sql-50 leetcode-advanced-sql-solutions

Resources

Readme
Activity

Stars

103 stars

Watchers

1 watching

Forks

32 forks
Report repository

Releases

No releases published

Packages

No packages published