LeetCode-SQL50-Solutions
The SQL 50 collection on LeetCode consists of a diverse range of SQL problems designed to assess and enhance your SQL skills. These problems cover a wide array of SQL concepts, including basic queries, subqueries, joins, aggregations, window functions, and more.
File Explorer
Download Latest Version (.zip)- 1164. Product Price at a Given Date.sql
- 1204. Last Person to Fit in the Bus.sql
- 1731. The Number of Employees Which Report to Each Employee.sql
- 1789. Primary Department for Each Employee.sql
- 180. Consecutive Numbers.sql
- 1907. Count Salary Categories.sql
- 610. Triangle Judgement.sql
- 1327. List the Products Ordered in a Period.sql
- 1484. Group Sold Products By The Date.sql
- 1517. Find Users With Valid E-Mails.sql
- 1527. Patients With a Condition.sql
- 1667. Fix Names in a Table.sql
- 196. Delete Duplicate Emails.sql
- 1075. Project Employees I.sql
- 1174. Immediate Food Delivery II.sql
- 1193. Monthly Transactions I.sql
- 1211. Queries Quality and Percentage.sql
- 1251. Average Selling Price.sql
- 1633. Percentage of Users Attended a Contest.sql
- 550. Game Play Analysis IV.sql
- 620. Not Boring Movies.sql
- 1068. Product Sales Analysis I.sql
- 1280. Students and Examinations.sql
- 1378. Replace Employee ID With The Unique Identifier.sql
- 1581. Customer Who Visited but Did Not Make Any Transactions.sql
- 1661. Average Time of Process per Machine.sql
- 1934. Confirmation Rate.sql
- 197. Rising Temperature.sql
- 570. Managers with at Least 5 Direct Reports.sql
- 577. Employee Bonus.sql
- 1148. Article Views I.sql
- 1683. Invalid Tweets.sql
- 1757. Recyclable and Low Fat Products.sql
- 584. Find Customer Referee.sql
- 595. Big Countries.sql
- 1045. Customers Who Bought All Products.sql
- 1070. Product Sales Analysis III.sql
- 1141. User Activity for the Past 30 Days I.sql
- 1729. Find Followers Count.sql
- 2356. Number of Unique Subjects Taught by Each Teacher.sql
- 596. Classes More Than 5 Students.sql
- 619. Biggest Single Number.sql
- 1321. Restaurant Growth.sql
- 1341. Movie Rating.sql
- 185. Department Top Three Salaries.sql
- 1978. Employees Whose Manager Left the Company.sql
- 585. Investments in 2016.sql
- 602. Friend Requests II: Who Has the Most Friends.sql
- 626. Exchange Seats.sql
- README.md
// repository documentation
Was this content helpful?
(0 ratings)