Skip to content

pratyushpanda91/SQL-50-Leetcode-solutions

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

51 Commits
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
 
 
1_Maximum Score After Splitting a String.sql
1_Maximum Score After Splitting a String.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_Number of Unique Subjects Taught by Each Teacher.sql
23_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_045. Customers Who Bought All Products.sql
29_045. Customers Who Bought All Products.sql
 
 
2_584_Find Customer Referee.sql
2_584_Find Customer Referee.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
 
 
32 610. Triangle Judgement.sql
32 610. Triangle Judgement.sql
 
 
33_180. Consecutive Numbers.sql
33_180. Consecutive Numbers.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_Exchange Seats.sql
38_Exchange Seats.sql
 
 
39_1341. Movie Rating.sql
39_1341. Movie Rating.sql
 
 
3_595_Big Countries.sql
3_595_Big Countries.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
 
 
4_1148_Article Views I.sql
4_1148_Article Views I.sql
 
 
5_1683_Invalid tweets.sql
5_1683_Invalid tweets.sql
 
 
6_1378_Replace Employee ID With The Unique Identifier.sql
6_1378_Replace Employee ID With The Unique Identifier.sql
 
 
7_1068_Product Sales Analysis I.sql
7_1068_Product Sales Analysis I.sql
 
 
8_1581_Customer Who Visited but Did Not Make Any Transactions.sql
8_1581_Customer Who Visited but Did Not Make Any Transactions.sql
 
 
9_197_Rising Temperature.sql
9_197_Rising Temperature.sql
 
 
README.md
README.md
 
 

Repository files navigation

SQL-50-Leetcode-solutions

Welcome to my SQL 50 LeetCode Solutions repository! 🎉
This repository contains my solutions to the most common and essential SQL problems on LeetCode, focusing on improving database query skills and mastering SQL concepts.

📝 Overview

This project aims to:

  • Solve all 50 SQL problems from LeetCode.
  • Provide clean, efficient and well-managed SQL solutions.
  • Share day and problem count for each problem.

🚀 Structure of the Repository

Each solution is organized as follows:

  • Problem Title: Matches the problem name on LeetCode.
  • Solution: The SQL query with comments explaining the logic in hard questions.

Author

About

Here is given all solution from day 1 . Question are from below link .

leetcode.com/studyplan/top-sql-50/

Topics

mysql sql leetcode-solutions

Resources

Readme
Activity

Stars

2 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published