Repository files navigation

leetcode-sql

Repository Contains:

(1) 120+ Leetcode SQL Question Solutions (2) PostgreSQL Dump File (leetcodedb.sql)

SQL Dump File of PostgreSQL will create all the required tables in your own PostgreSQL setup.

Note : (1) Table Names are suffixed with question number. (2) Will add more solutions as i solve.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

leetcode-sql

Repository Contains:

About

Releases

Packages

Name		Name	Last commit message	Last commit date
Latest commit History 29 Commits
dump_file		dump_file
1045. Customers Who Bought All Products.txt		1045. Customers Who Bought All Products.txt
1050. Actors and Directors Who Cooperated At Least Three Times.txt		1050. Actors and Directors Who Cooperated At Least Three Times.txt
1068. Product Sales Analysis I.txt		1068. Product Sales Analysis I.txt
1069. Product Sales Analysis II.txt		1069. Product Sales Analysis II.txt
1070. Product Sales Analysis III.txt		1070. Product Sales Analysis III.txt
1075. Project Employees I.txt		1075. Project Employees I.txt
1076. Project Employees II.txt		1076. Project Employees II.txt
1077. Project Employees III.txt		1077. Project Employees III.txt
1082. Sales Analysis I.txt		1082. Sales Analysis I.txt
1083. Sales Analysis II.txt		1083. Sales Analysis II.txt
1084. Sales Analysis III.txt		1084. Sales Analysis III.txt
1097. Game Play Analysis V.txt		1097. Game Play Analysis V.txt
1098. Unpopular Books.txt		1098. Unpopular Books.txt
1107. New Users Daily Count.txt		1107. New Users Daily Count.txt
1112. Highest Grade For Each Student.txt		1112. Highest Grade For Each Student.txt
1113.Reported Posts.txt		1113.Reported Posts.txt
1126. Active Businesses.txt		1126. Active Businesses.txt
1127. User Purchase Platform.txt		1127. User Purchase Platform.txt
1132. Reported Posts II.txt		1132. Reported Posts II.txt
1141. User Activity for the Past 30 Days I.txt		1141. User Activity for the Past 30 Days I.txt
1142. User Activity for the Past 30 Days II.txt		1142. User Activity for the Past 30 Days II.txt
1148. Article Views I.txt		1148. Article Views I.txt
1149. Article Views II.txt		1149. Article Views II.txt
1158. Market Analysis I.txt		1158. Market Analysis I.txt
1159. Market Analysis II.txt		1159. Market Analysis II.txt
1164. Product Price at a Given Date.txt		1164. Product Price at a Given Date.txt
1173. Immediate Food Delivery I.txt		1173. Immediate Food Delivery I.txt
1174. Immediate Food Delivery II.txt		1174. Immediate Food Delivery II.txt
1179. Reformat Department Table.txt		1179. Reformat Department Table.txt
1193. Monthly Transactions I.txt		1193. Monthly Transactions I.txt
1194. Tournament Winners.txt		1194. Tournament Winners.txt
1204. Last Person to Fit in the Elevator.txt		1204. Last Person to Fit in the Elevator.txt
1205. Monthly Transactions II.txt		1205. Monthly Transactions II.txt
1211. Queries Quality and Percentage.txt		1211. Queries Quality and Percentage.txt
1212. Team Scores in Football Tournament.txt		1212. Team Scores in Football Tournament.txt
1225. Report Contiguous Dates.txt		1225. Report Contiguous Dates.txt
1264. Page Recommendations.txt		1264. Page Recommendations.txt
1270. All People Report to the Given Manager.txt		1270. All People Report to the Given Manager.txt
1285. Find the Start and End Number of Continuous Ranges.txt		1285. Find the Start and End Number of Continuous Ranges.txt
1308. Running Total for Different Genders.txt		1308. Running Total for Different Genders.txt
1321. Restaurant Growth.txt		1321. Restaurant Growth.txt
1336. Number of Transactions per Visit.txt		1336. Number of Transactions per Visit.txt
1341. Movie Rating.txt		1341. Movie Rating.txt
1355. Activity Participants.txt		1355. Activity Participants.txt
1364. Number of Trusted Contacts of a Customer.txt		1364. Number of Trusted Contacts of a Customer.txt
1393. Capital Gain Loss.txt		1393. Capital Gain Loss.txt
1398. Customers Who Bought Products A and B but Not C.txt		1398. Customers Who Bought Products A and B but Not C.txt
1412. Find the Quiet Students in All Exams.txt		1412. Find the Quiet Students in All Exams.txt
1421. NPV Queries.txt		1421. NPV Queries.txt
1440. Evaluate Boolean Expression.txt		1440. Evaluate Boolean Expression.txt
1445. Apples & Oranges.txt		1445. Apples & Oranges.txt
1454. Active Users.txt		1454. Active Users.txt
1459. Rectangles Area.txt		1459. Rectangles Area.txt
1468. Calculate Salaries.txt		1468. Calculate Salaries.txt
1479. Sales by Day of the Week.txt		1479. Sales by Day of the Week.txt
1501. Countries You Can Safely Invest In.txt		1501. Countries You Can Safely Invest In.txt
1532. The Most Recent Three Orders.txt		1532. The Most Recent Three Orders.txt
1549. The Most Recent Orders for Each Product.txt		1549. The Most Recent Orders for Each Product.txt
1555. Bank Account Summary.txt		1555. Bank Account Summary.txt
1596. The Most Frequently Ordered Products for Each Customer.txt		1596. The Most Frequently Ordered Products for Each Customer.txt
1613. Find the Missing IDs.txt		1613. Find the Missing IDs.txt
1635. Hopper Company Queries I.txt		1635. Hopper Company Queries I.txt
1645. Hopper Company Queries II.txt		1645. Hopper Company Queries II.txt
1651. Hopper Company Queries III.txt		1651. Hopper Company Queries III.txt
1699. Number of Calls Between Two Persons.txt		1699. Number of Calls Between Two Persons.txt
1709. Biggest Window Between Visits.txt		1709. Biggest Window Between Visits.txt
1715. Count Apples and Oranges.txt		1715. Count Apples and Oranges.txt
1747. Leetflex Banned Accounts.txt		1747. Leetflex Banned Accounts.txt
175. Combine Two Tables.txt		175. Combine Two Tables.txt
176. Second Highest Salary.txt		176. Second Highest Salary.txt
1767. Find the Subtasks That Did Not Execute.txt		1767. Find the Subtasks That Did Not Execute.txt
177. Nth Highest Salary.txt		177. Nth Highest Salary.txt
178. Rank Scores.txt		178. Rank Scores.txt
1783. Grand Slam Titles.txt		1783. Grand Slam Titles.txt
180. Consecutive Numbers.txt		180. Consecutive Numbers.txt
181. Employees Earning More Than Their Managers.txt		181. Employees Earning More Than Their Managers.txt
182. Duplicate Emails.txt		182. Duplicate Emails.txt
183. Customers Who Never Order.txt		183. Customers Who Never Order.txt
184. Department Highest Salary.txt		184. Department Highest Salary.txt
185. Department Top Three Salaries.txt		185. Department Top Three Salaries.txt
196. Delete Duplicate Emails.txt		196. Delete Duplicate Emails.txt
197. Rising Temperature.txt		197. Rising Temperature.txt
262. Trips and Users.txt		262. Trips and Users.txt
511. Game Play Analysis I.txt		511. Game Play Analysis I.txt
512. Game Play Analysis II.txt		512. Game Play Analysis II.txt
534. Game Play Analysis III.txt		534. Game Play Analysis III.txt
550. Game Play Analysis IV.txt		550. Game Play Analysis IV.txt
569. Median Employee Salary.txt		569. Median Employee Salary.txt
570. Managers with at Least 5 Direct Reports.txt		570. Managers with at Least 5 Direct Reports.txt
571. Find Median Given Frequency of Numbers.txt		571. Find Median Given Frequency of Numbers.txt
574. Winning Candidate.txt		574. Winning Candidate.txt
577. Employee Bonus.txt		577. Employee Bonus.txt
578. Get Highest Answer Rate Question.txt		578. Get Highest Answer Rate Question.txt
579. Find Cumulative Salary of an Employee.txt		579. Find Cumulative Salary of an Employee.txt
580. Count Student Number in Departments.txt		580. Count Student Number in Departments.txt
584. Find Customer Referee.txt		584. Find Customer Referee.txt
585. Investments in 2016.txt		585. Investments in 2016.txt
586. Customer Placing the Largest Number of Orders.txt		586. Customer Placing the Largest Number of Orders.txt
595. Big Countries.txt		595. Big Countries.txt

chilubagh/leetcode-sql

Folders and files

Latest commit

History

Repository files navigation

leetcode-sql

Repository Contains:

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Packages