Skip to content

This repository contains solutions to 50 advanced SQL problems from the LeetCode Premium subscription along with its solutions. These problems focus on complex query writing, optimization, and advanced SQL concepts.

Notifications You must be signed in to change notification settings

geekydevin/Leetcode-Advanced-SQL-50

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

leetcode-advanced_sql_50

LeetCode Topics

Database

0175-combine-two-tables
0182-duplicate-emails
0183-customers-who-never-order
0184-department-highest-salary
0586-customer-placing-the-largest-number-of-orders
0603-consecutive-available-seats
0607-sales-person
0608-tree-node
0613-shortest-distance-in-a-line
1136-actors-and-directors-who-cooperated-at-least-three-times
1163-project-employees-iii
1179-game-play-analysis-i
1180-game-play-analysis-ii
1181-game-play-analysis-iii
1214-highest-grade-for-each-student
1291-immediate-food-delivery-i
1339-team-scores-in-football-tournament
1357-report-contiguous-dates
1399-page-recommendations
1405-all-people-report-to-the-given-manager
1420-find-the-start-and-end-number-of-continuous-ranges
1438-find-the-team-size
1481-students-with-invalid-departments
1536-customers-who-bought-products-a-and-b-but-not-c
1541-top-travellers
1546-find-the-quiet-students-in-all-exams
1565-evaluate-boolean-expression
1578-apples-oranges
1639-friendly-movies-streamed-last-month
1641-countries-you-can-safely-invest-in
1654-customer-order-frequency
1671-the-most-recent-three-orders
1688-the-most-recent-orders-for-each-product
1718-warehouse-manager
1734-bank-account-summary-ii
1735-the-most-frequently-ordered-products-for-each-customer
1749-sellers-with-no-sales
1837-daily-leads-and-partners
1842-number-of-calls-between-two-persons
1852-biggest-window-between-visits
1892-find-total-time-spent-by-each-employee
1898-leetflex-banned-accounts
1914-find-the-subtasks-that-did-not-execute
1932-grand-slam-titles
1948-rearrange-products-table
1974-find-customers-with-positive-revenue-this-year
1981-maximum-transaction-each-day
2024-calculate-special-bonus
2041-the-latest-login-in-2020
2110-employees-with-missing-information

About

This repository contains solutions to 50 advanced SQL problems from the LeetCode Premium subscription along with its solutions. These problems focus on complex query writing, optimization, and advanced SQL concepts.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published