GitHub - tejgit8102/SQL-50-LeetCode: 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.

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.

Navigation Menu

Repository files navigation

About

Releases

Packages

Contributors

Name		Name	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

Folders and files

Latest commit

History

Repository files navigation

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors