Skip to content
/ SQL-50-LeetCode Public

The SQL-50-LeetCode GitHub repository contains my solutions to the top 50 most frequently asked SQL problems on LeetCode. I've included detailed queries and optimized approaches to improve SQL skills. This repository is perfect for practice and interview preparation, helping aspiring data professionals enhance their proficiency.

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

tejgit8102/SQL-50-LeetCode

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

57 Commits
01_1757_Recyclable_and_Low_Fat_Products.sql
01_1757_Recyclable_and_Low_Fat_Products.sql
 
 
02_584_Find_Customer_Referee.sql
02_584_Find_Customer_Referee.sql
 
 
03_1148_Article_Views_I.sql
03_1148_Article_Views_I.sql
 
 
04_595_Big_Countries.sql
04_595_Big_Countries.sql
 
 
05_1683_Invalid_Tweets.sql
05_1683_Invalid_Tweets.sql
 
 
06_1378_Replace_Employee_ID_With_The_Unique_Identifier.sql
06_1378_Replace_Employee_ID_With_The_Unique_Identifier.sql
 
 
07_1068_Product_Sales_Analysis_I.sql
07_1068_Product_Sales_Analysis_I.sql
 
 
08_1581_Customer_Who_Visited_but_Did_Not_Make_Any_Transactions.sql
08_1581_Customer_Who_Visited_but_Did_Not_Make_Any_Transactions.sql
 
 
09_197_Rising_Temperature.sql
09_197_Rising_Temperature.sql
 
 
10_1661_Average_Time_of_Process_per_Machine.sql
10_1661_Average_Time_of_Process_per_Machine.sql
 
 
11_577_Employee_Bonus.sql
11_577_Employee_Bonus.sql
 
 
12_1280_Students_and_Examinations.sql
12_1280_Students_and_Examinations.sql
 
 
13_570_Managers_with_at_Least_5_Direct_Reports.sql
13_570_Managers_with_at_Least_5_Direct_Reports.sql
 
 
14_1934_Confirmation_Rate.sql
14_1934_Confirmation_Rate.sql
 
 
15_620_Not_Boring_Movies.sql
15_620_Not_Boring_Movies.sql
 
 
16_1251_Average_Selling-Price.sql
16_1251_Average_Selling-Price.sql
 
 
17_1075_Project_Employees_I.sql
17_1075_Project_Employees_I.sql
 
 
18_1633_Percentage_of_Users_Attended_a_Contest.sql
18_1633_Percentage_of_Users_Attended_a_Contest.sql
 
 
19_1211_Queries_Quality_and_Percentage.sql
19_1211_Queries_Quality_and_Percentage.sql
 
 
20_1193_Monthly_Transactions_I.sql
20_1193_Monthly_Transactions_I.sql
 
 
21_1174_Immediate_Food_Delivery_II.sql
21_1174_Immediate_Food_Delivery_II.sql
 
 
22_550_Game_Play_Analysis_IV.sql
22_550_Game_Play_Analysis_IV.sql
 
 
23_2356_Number_of_Unique_Subjects_Taught_by_Each_Teacher.sql
23_2356_Number_of_Unique_Subjects_Taught_by_Each_Teacher.sql
 
 
24_1141_User_Activity_for_the_Past_30_Days_I.sql
24_1141_User_Activity_for_the_Past_30_Days_I.sql
 
 
25_1070_Product_Sales_Analysis_III.sql
25_1070_Product_Sales_Analysis_III.sql
 
 
26_596_Classes_More_Than_5_Students.sql
26_596_Classes_More_Than_5_Students.sql
 
 
27_1729_Find_Followers_Count.sql
27_1729_Find_Followers_Count.sql
 
 
28_619_Biggest_Single_Number.sql
28_619_Biggest_Single_Number.sql
 
 
29_1045_Customers_Who_Bought_All_Products.sql
29_1045_Customers_Who_Bought_All_Products.sql
 
 
30_1731_The_Number_of_Employees_Which_Report_to_Each_Employee.sql
30_1731_The_Number_of_Employees_Which_Report_to_Each_Employee.sql
 
 
31_1789_Primary_Department_for_Each_Employee.sql
31_1789_Primary_Department_for_Each_Employee.sql
 
 
32_610_Triangle_Judgement.sql
32_610_Triangle_Judgement.sql
 
 
33_180_Consecutive_Numbers.sql
33_180_Consecutive_Numbers.sql
 
 
34_1164_Product_Price_at_a_Given_Date.sql
34_1164_Product_Price_at_a_Given_Date.sql
 
 
35_1204_Last_Person_to_Fit_in_the_Bus.sql
35_1204_Last_Person_to_Fit_in_the_Bus.sql
 
 
36_1907_Count_Salary_Categories.sql
36_1907_Count_Salary_Categories.sql
 
 
37_1978_Employees_Whose_Manager_Left_the_Company.sql
37_1978_Employees_Whose_Manager_Left_the_Company.sql
 
 
38_626_Exchange_Seats.sql
38_626_Exchange_Seats.sql
 
 
39_1341_Movie_Rating.sql
39_1341_Movie_Rating.sql
 
 
40_1321_Restaurant_Growth.sql
40_1321_Restaurant_Growth.sql
 
 
41_602_Friend_Requests_II:Who_Has_the_Most_Friends.sql
41_602_Friend_Requests_II:Who_Has_the_Most_Friends.sql
 
 
42_585_Investments_in_2016.sql
42_585_Investments_in_2016.sql
 
 
43_185_Department_Top_Three_Salaries.sql
43_185_Department_Top_Three_Salaries.sql
 
 
44_1667_Fix_Names_in_a_Table.sql
44_1667_Fix_Names_in_a_Table.sql
 
 
45_1527_Patients_With_a_Condition.sql
45_1527_Patients_With_a_Condition.sql
 
 
46_196_Delete_Duplicate_Emails.sql
46_196_Delete_Duplicate_Emails.sql
 
 
47_176_Second_Highest_Salary.sql
47_176_Second_Highest_Salary.sql
 
 
48_1484_Group_Sold_Products_By_The_Date.sql
48_1484_Group_Sold_Products_By_The_Date.sql
 
 
49_1327_List_the_Products_Ordered_in_a_Period.sql
49_1327_List_the_Products_Ordered_in_a_Period.sql
 
 
50_1517_Find_Users_With_Valid_E-Mails.sql
50_1517_Find_Users_With_Valid_E-Mails.sql
 
 
README.md
README.md
 
 

Repository files navigation

SQL LeetCode Solutions

This repository contains SQL solutions for various problems from LeetCode.

Each solution is optimized for clarity and efficiency. Solutions cover a wide range of SQL concepts including joins, subqueries, aggregations, and window functions. Problems are categorized by difficulty (Easy, Medium, Hard). SQL queries are tested against LeetCode's database schema for accuracy and performance.

About

The SQL-50-LeetCode GitHub repository contains my solutions to the top 50 most frequently asked SQL problems on LeetCode. I've included detailed queries and optimized approaches to improve SQL skills. This repository is perfect for practice and interview preparation, helping aspiring data professionals enhance their proficiency.

Topics

mysql sql

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published