leetcode-sql

LeetCode SQL Practice

Daily SQL problem-solving practice, one solution file per problem.

Progress

20 problems solved, spanning easy to medium difficulty (problem #197 through #1934).

Structure

Each file is named <problem-number>-<problem-title>.sql and contains my solution to that LeetCode problem.

Navigation Menu

Repository files navigation

leetcode-sql

LeetCode SQL Practice

Progress

Structure

About

Releases

Packages

Contributors

Name		Name	Last commit message	Last commit date
1045-Customers-who-bought-all-products.sql		1045-Customers-who-bought-all-products.sql
1068-Product-Sales-Analysis-I.sql		1068-Product-Sales-Analysis-I.sql
1070-Product-Sales-Analysis-III.sql		1070-Product-Sales-Analysis-III.sql
1075-Project-employees-I.sql		1075-Project-employees-I.sql
1141-User-activities-for-the-past-30-days-I.sql		1141-User-activities-for-the-past-30-days-I.sql
1148-Article-Views-I.sql		1148-Article-Views-I.sql
1174-Immediate-Food-Delivery-II.sql		1174-Immediate-Food-Delivery-II.sql
1193-Monthly-transactions-I.sql		1193-Monthly-transactions-I.sql
1211-Queries-quality-and-percentage.sql		1211-Queries-quality-and-percentage.sql
1251-Average-selling-price.sql		1251-Average-selling-price.sql
1280-Students-and-examinations.sql		1280-Students-and-examinations.sql
1378-Replace-employee-id-with-the-unique-identifier.sql		1378-Replace-employee-id-with-the-unique-identifier.sql
1581-Customers-who-visisted-but-did-not-make-any-transactions.sql		1581-Customers-who-visisted-but-did-not-make-any-transactions.sql
1633-Percentage-of-users-attended-a-contest.sql		1633-Percentage-of-users-attended-a-contest.sql
1661-Average-time-of-process-per-machine.sql		1661-Average-time-of-process-per-machine.sql
1683-Invalid-Tweets.sql		1683-Invalid-Tweets.sql
1729-Find-followers-count.sql		1729-Find-followers-count.sql
1731--The number of employees who report to each employee.sql		1731--The number of employees who report to each employee.sql
1789-Primary-department-for-each-employee.sql		1789-Primary-department-for-each-employee.sql
1873-recyclable-and-low-fat-products.sql		1873-recyclable-and-low-fat-products.sql
1934-Confirmation-rate-Medium.sql		1934-Confirmation-rate-Medium.sql
197-Rising-Temperature.sql		197-Rising-Temperature.sql
2356-Number of quinues subjects taught by each teacher - Easy.sql		2356-Number of quinues subjects taught by each teacher - Easy.sql
570-Managers with at Least 5 Direct Reports.sql		570-Managers with at Least 5 Direct Reports.sql
577-Employee-Bonus.sql		577-Employee-Bonus.sql
584. Find Customer Referee.sql		584. Find Customer Referee.sql
595-Big-Counties.sql		595-Big-Counties.sql
596-Classes-with-at-least-5-students.sql		596-Classes-with-at-least-5-students.sql
610-Triangle-Judgement.sql		610-Triangle-Judgement.sql
619 - Biggest single number.sql		619 - Biggest single number.sql
620-Not-boring-movies.sql		620-Not-boring-movies.sql
README.md		README.md

Latest commit

History

Folders and files

Repository files navigation

leetcode-sql

LeetCode SQL Practice

Progress

Structure

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors