Skip to content

assemmkhalil/LeetCodeSQL50

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
.gitignore
.gitignore
 
 
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 Activity for the Past 30 Days I.sql
1141. User Activity for the Past 30 Days I.sql
 
 
1148. Article Views I.sql
1148. Article Views I.sql
 
 
1164. Product Price at a Given Date.sql
1164. Product Price at a Given Date.sql
 
 
1174. Immediate Food Delivery II.sql
1174. Immediate Food Delivery II.sql
 
 
1193. Monthly Transactions I.sql
1193. Monthly Transactions I.sql
 
 
1204. Last Person to Fit in the Bus.sql
1204. Last Person to Fit in the Bus.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
 
 
1321. Restaurant Growth.sql
1321. Restaurant Growth.sql
 
 
1327. List the Products Ordered in a Period.sql
1327. List the Products Ordered in a Period.sql
 
 
1341. Movie Rating.sql
1341. Movie Rating.sql
 
 
1378. Replace Employee ID With The Unique Identifier.sql
1378. Replace Employee ID With The Unique Identifier.sql
 
 
1484. Group Sold Products By The Date.sql
1484. Group Sold Products By The Date.sql
 
 
1517. Find Users With Valid E-Mails.sql
1517. Find Users With Valid E-Mails.sql
 
 
1527. Patients With a Condition.sql
1527. Patients With a Condition.sql
 
 
1581. Customer Who Visited but Did Not Make Any Transactions.sql
1581. Customer Who Visited 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
 
 
1667. Fix Names in a Table.sql
1667. Fix Names in a Table.sql
 
 
1683. Invalid Tweets.sql
1683. Invalid Tweets.sql
 
 
1729. Find Followers Count.sql
1729. Find Followers Count.sql
 
 
1731. The Number of Employees Which Report to Each Employee.sql
1731. The Number of Employees Which Report to Each Employee.sql
 
 
1757. Recyclable and Low Fat Products.sql
1757. Recyclable and Low Fat Products.sql
 
 
176. Second Highest Salary.sql
176. Second Highest Salary.sql
 
 
1789. Primary Department for Each Employee.sql
1789. Primary Department for Each Employee.sql
 
 
180. Consecutive Numbers.sql
180. Consecutive Numbers.sql
 
 
185. Department Top Three Salaries.sql
185. Department Top Three Salaries.sql
 
 
1907. Count Salary Categories.sql
1907. Count Salary Categories.sql
 
 
1934. Confirmation Rate.sql
1934. Confirmation Rate.sql
 
 
196. Delete Duplicate Emails.sql
196. Delete Duplicate Emails.sql
 
 
197. Rising Temperature.sql
197. Rising Temperature.sql
 
 
1978. Employees Whose Manager Left the Company.sql
1978. Employees Whose Manager Left the Company.sql
 
 
2356. Number of Unique Subjects Taught by Each Teacher.sql
2356. Number of Unique Subjects Taught by Each Teacher.sql
 
 
550. Game Play Analysis IV.sql
550. Game Play Analysis IV.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
 
 
585. Investments in 2016.sql
585. Investments in 2016.sql
 
 
595. Big Countries.sql
595. Big Countries.sql
 
 
596. Classes More Than 5 Students.sql
596. Classes More Than 5 Students.sql
 
 
602. Friend Requests II Who Has the Most Friends.sql
602. Friend Requests II Who Has the Most Friends.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
 
 
626. Exchange Seats.sql
626. Exchange Seats.sql
 
 
README.md
README.md
 
 

Repository files navigation

LeetCode SQL 50 Challenge Overview

Questions: https://leetcode.com/studyplan/top-sql-50/

The LeetCode SQL 50 challenge contains 50 SQL based data and database questions of increasing difficulty to test SQL skills. Completing this challenge helps demonstrate ability to use SQL for analytics and solution development.

Challenge Details

  • Covers wide range of SQL topics including SELECT, JOIN, aggregation, sorting and grouping, date manipulation, window functions, subqueries, string functions and Regex, etc.
  • Questions categorized as Easy, Medium and Hard difficulty
  • Real-world business cases like calculating customer analytics, generating reports, manipulating data
  • Solutions can be implemented in any SQL dialect like MySQL, PostgreSQL, SQL Server

The solutions can serve as examples and reference for future projects.

About

My solutions to LeetCode SQL 50 challenge questions

Topics

sql problem-solving

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published