Skip to content
/ SQL-50-Leetcode-Problems Public

The SQL 50 collection on LeetCode offers a diverse set of problems aimed at evaluating and improving your SQL skills. It covers a broad spectrum of concepts, including fundamental queries, subqueries, joins, aggregations, window functions, and other advanced techniques.

leetcode.com/studyplan/top-sql-50/
1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

evanmathew/SQL-50-Leetcode-Problems

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

92 Commits
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 .sql
1141. User Activity for the Past 30 Days .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 Practice on LeetCode

This repository contains solutions and explanations for the SQL 50 challenge on LeetCode, designed to enhance SQL skills by covering a variety of core and advanced concepts.

Overview

The SQL 50 collection on LeetCode provides a diverse set of SQL problems ranging from easy to hard. These exercises are ideal for anyone looking to strengthen their SQL knowledge and prepare for technical interviews or real-world data tasks.

Topics Covered:

  • Basic Queries – Select statements and filtering
  • Joins – Inner, Left, Right, and Full joins
  • Aggregate Functions – SUM(), COUNT(), AVG(), etc.
  • Sorting and Grouping – ORDER BY, GROUP BY, and HAVING
  • Subqueries – Correlated and non-correlated subqueries
  • Window Functions – RANK(), ROW_NUMBER(), PARTITION BY
  • String Functions and Regex – Text manipulation and pattern matching

Happy Coding! 🎉

About

The SQL 50 collection on LeetCode offers a diverse set of problems aimed at evaluating and improving your SQL skills. It covers a broad spectrum of concepts, including fundamental queries, subqueries, joins, aggregations, window functions, and other advanced techniques.

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

Topics

mysql leetcode-questions leetcode-sql-50 50-sql-solution

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository