Skip to content
/ Leetcode-SQL50 Public

This repository contains solutions to the top 50 SQL questions from LeetCode, implemented in both standard SQL and PostgreSQL. It serves as a comprehensive practice resource for anyone looking to enhance their SQL querying skills and deepen their understanding of PostgreSQL-specific features.

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

diwanshwho/Leetcode-SQL50

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

87 Commits
1 Recyclable and Low Fat Products
1 Recyclable and Low Fat Products
 
 
10 Employee Bonus
10 Employee Bonus
 
 
11 Students and Examinations
11 Students and Examinations
 
 
12 Average Time of Process per Machine
12 Average Time of Process per Machine
 
 
13 Confirmation Rate
13 Confirmation Rate
 
 
14 Not Boring Movies
14 Not Boring Movies
 
 
15 Average Selling Price
15 Average Selling Price
 
 
16 Project Employees I
16 Project Employees I
 
 
17 Percentage of Users Attended a Contest
17 Percentage of Users Attended a Contest
 
 
18 Queries Quality and Percentage
18 Queries Quality and Percentage
 
 
19 Monthly Transactions I
19 Monthly Transactions I
 
 
2 Find Customer Referee
2 Find Customer Referee
 
 
20 Managers with at Least 5 Direct Reports
20 Managers with at Least 5 Direct Reports
 
 
21 Immediate Food Delivery II
21 Immediate Food Delivery II
 
 
22 Number of Unique Subjects Taught by Each Teacher
22 Number of Unique Subjects Taught by Each Teacher
 
 
23 User Activity for the Past 30 Days I
23 User Activity for the Past 30 Days I
 
 
24 Product Sales Analysis III
24 Product Sales Analysis III
 
 
25 Classes More Than 5 Students
25 Classes More Than 5 Students
 
 
26 Find Followers Count
26 Find Followers Count
 
 
27 Biggest Single Number
27 Biggest Single Number
 
 
28 Customers Who Bought All Products
28 Customers Who Bought All Products
 
 
29 Game Play Analysis IV
29 Game Play Analysis IV
 
 
3 Big Countries
3 Big Countries
 
 
30 Triangle Judgement
30 Triangle Judgement
 
 
31 Fix Names in a Table
31 Fix Names in a Table
 
 
32 Patients With a Condition
32 Patients With a Condition
 
 
33 Delete Duplicate Emails
33 Delete Duplicate Emails
 
 
34 Group Sold Products By The Date
34 Group Sold Products By The Date
 
 
35 Primary Department for Each Employee
35 Primary Department for Each Employee
 
 
4 Article Views I
4 Article Views I
 
 
5 Invalid Tweets
5 Invalid Tweets
 
 
6 Replace Employee ID With The Unique Identifier
6 Replace Employee ID With The Unique Identifier
 
 
7 Product Sales Analysis I
7 Product Sales Analysis I
 
 
8 Customer Who Visited but Did Not Make Any Transactions
8 Customer Who Visited but Did Not Make Any Transactions
 
 
9 Rising Temperature
9 Rising Temperature
 
 
README.md
README.md
 
 

Repository files navigation

Leetcode-SQL50

This repository contains solutions to the top 50 SQL questions from LeetCode, implemented in both standard SQL and PostgreSQL. It serves as a comprehensive practice resource for anyone looking to enhance their SQL querying skills and deepen their understanding of PostgreSQL-specific features.

download

About

This repository contains solutions to the top 50 SQL questions from LeetCode, implemented in both standard SQL and PostgreSQL. It serves as a comprehensive practice resource for anyone looking to enhance their SQL querying skills and deepen their understanding of PostgreSQL-specific features.

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published