SQL — LeetCode SQL Solutions

Professional, well-documented MySQL solutions for selected LeetCode database problems. Each problem lives in its own numbered folder and includes a concise solution and a short explanation.

Generated with LeetHub v2: https://github.com/arunbhardwaj/LeetHub-2.0

LeetCode Topics

Repository Contents

• 0177-nth-highest-salary — SQL solution and problem notes

Database

0175-combine-two-tables
0176-second-highest-salary
0178-rank-scores
0180-consecutive-numbers
0184-department-highest-salary
0185-department-top-three-salaries
0196-delete-duplicate-emails
0197-rising-temperature
0262-trips-and-users
0511-game-play-analysis-i
0550-game-play-analysis-iv
0570-managers-with-at-least-5-direct-reports
0577-employee-bonus
0585-investments-in-2016
0596-classes-with-at-least-5-students
0601-human-traffic-of-stadium
0602-friend-requests-ii-who-has-the-most-friends
0607-sales-person
0608-tree-node
0610-triangle-judgement
0619-biggest-single-number
0620-not-boring-movies
0626-exchange-seats
0627-swap-sex-of-employees
1045-customers-who-bought-all-products
1050-actors-and-directors-who-cooperated-at-least-three-times
1068-product-sales-analysis-i
1070-product-sales-analysis-iii
1075-project-employees-i
1084-sales-analysis-iii
1141-user-activity-for-the-past-30-days-i
1158-market-analysis-i
1164-product-price-at-a-given-date
1174-immediate-food-delivery-ii
1179-reformat-department-table
1193-monthly-transactions-i
1204-last-person-to-fit-in-the-bus
1211-queries-quality-and-percentage
1280-students-and-examinations
1321-restaurant-growth
1327-list-the-products-ordered-in-a-period
1341-movie-rating
1378-replace-employee-id-with-the-unique-identifier
1393-capital-gainloss
1407-top-travellers
1484-group-sold-products-by-the-date
1517-find-users-with-valid-e-mails
1527-patients-with-a-condition
1581-customer-who-visited-but-did-not-make-any-transactions
1587-bank-account-summary-ii
1633-percentage-of-users-attended-a-contest
1661-average-time-of-process-per-machine
1667-fix-names-in-a-table
1693-daily-leads-and-partners
1729-find-followers-count
1731-the-number-of-employees-which-report-to-each-employee
1741-find-total-time-spent-by-each-employee
1789-primary-department-for-each-employee
1795-rearrange-products-table
1873-calculate-special-bonus
1890-the-latest-login-in-2020
1907-count-salary-categories
1934-confirmation-rate
1965-employees-with-missing-information
1978-employees-whose-manager-left-the-company
2356-number-of-unique-subjects-taught-by-each-teacher
3421-find-students-who-improved
3436-find-valid-emails
3451-find-invalid-ip-addresses
3475-dna-pattern-recognition
3482-analyze-organization-hierarchy
3497-analyze-subscription-conversion
3521-find-product-recommendation-pairs
3554-find-category-recommendation-pairs
3564-seasonal-sales-analysis
3570-find-books-with-no-available-copies
3586-find-covid-recovery-patients
3601-find-drivers-with-improved-fuel-efficiency
3611-find-overbooked-employees

Project Overview

This repository collects clear, idiomatic MySQL solutions to common LeetCode database problems. Solutions are intended to be readable, correct, and suitable as references when preparing for technical interviews.

Repository Structure

• 0176-second-highest-salary/ — problem SQL and README
• 0177-nth-highest-salary/ — problem SQL and README