Leetcode-Advanced-SQL-50

KO | EN

gitlite — search

#javascript #python #react #ai #typescript #llm #golang #go #machine-learning #deep-learning #docker #nodejs #windows #kubernetes

Leetcode-Advanced-SQL-50

(★ 53)

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.

Leetcode-Advanced-SQL-50 Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# leetcode-advanced_sql_50

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

Leetcode-Advanced-SQL-50

Leetcode-Advanced-SQL-50 Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Leetcode-Advanced-SQL-50

Leetcode-Advanced-SQL-50 Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README