Skip to content
/ LeedCode-Database-Solution Public

All Database questions' solutions in LeedCode (except for those who need subscription). 力扣所有数据库相关题目的答案（除了需要订阅的题目）

License

GPL-3.0 license
0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

Caryio/LeedCode-Database-Solution

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

112 Commits
1045. Customers Who Bought All Products.md
1045. Customers Who Bought All Products.md
 
 
1050. Actors and Directors Who Cooperated At Least Three Times.md
1050. Actors and Directors Who Cooperated At Least Three Times.md
 
 
1068. Product Sales Analysis I.md
1068. Product Sales Analysis I.md
 
 
1070. Product Sales Analysis III.md
1070. Product Sales Analysis III.md
 
 
1075. Project Employees I.md
1075. Project Employees I.md
 
 
1084. Sales Analysis III.md
1084. Sales Analysis III.md
 
 
1141. User Activity for the Past 30 Days I.md
1141. User Activity for the Past 30 Days I.md
 
 
1148. Article Views I.md
1148. Article Views I.md
 
 
1158. Market Analysis I.md
1158. Market Analysis I.md
 
 
1164. Product Price at a Given Date.md
1164. Product Price at a Given Date.md
 
 
1174. Immediate Food Delivery II.md
1174. Immediate Food Delivery II.md
 
 
1179. Reformat Department Table.md
1179. Reformat Department Table.md
 
 
1193. Monthly Transactions I.md
1193. Monthly Transactions I.md
 
 
1204. Last Person to Fit in the Bus.md
1204. Last Person to Fit in the Bus.md
 
 
1211. Queries Quality and Percentage.md
1211. Queries Quality and Percentage.md
 
 
1251. Average Selling Price.md
1251. Average Selling Price.md
 
 
1280. Students and Examinations.md
1280. Students and Examinations.md
 
 
1321. Restaurant Growth.md
1321. Restaurant Growth.md
 
 
1327. List the Products Ordered in a Period.md
1327. List the Products Ordered in a Period.md
 
 
1341. Movie Rating.md
1341. Movie Rating.md
 
 
1378. Replace Employee ID With The Unique Identifier.md
1378. Replace Employee ID With The Unique Identifier.md
 
 
1393. Capital Gain Loss.md
1393. Capital Gain Loss.md
 
 
1407. Top Travellers.md
1407. Top Travellers.md
 
 
1484. Group Sold Products By The Date.md
1484. Group Sold Products By The Date.md
 
 
1517. Find Users With Valid E-Mails.md
1517. Find Users With Valid E-Mails.md
 
 
1527. Patients With a Condition.md
1527. Patients With a Condition.md
 
 
1581. Customer Who Visited but Did Not Make Any Transactions.md
1581. Customer Who Visited but Did Not Make Any Transactions.md
 
 
1587. Bank Account Summary II.md
1587. Bank Account Summary II.md
 
 
1633. Percentage of Users Attended a Contest.md
1633. Percentage of Users Attended a Contest.md
 
 
1661. Average Time of Process per Machine.md
1661. Average Time of Process per Machine.md
 
 
1667. Fix Names in a Table.md
1667. Fix Names in a Table.md
 
 
1683. Invalid Tweets.md
1683. Invalid Tweets.md
 
 
1693. Daily Leads and Partners.md
1693. Daily Leads and Partners.md
 
 
1729. Find Followers Count.md
1729. Find Followers Count.md
 
 
1731. The Number of Employees Which Report to Each Employee.md
1731. The Number of Employees Which Report to Each Employee.md
 
 
1741. Find Total Time Spent by Each Employee.md
1741. Find Total Time Spent by Each Employee.md
 
 
175. Combine Two Tables.md
175. Combine Two Tables.md
 
 
1757. Recyclable and Low Fat Products.md
1757. Recyclable and Low Fat Products.md
 
 
176. Second Highest Salary.md
176. Second Highest Salary.md
 
 
177. Nth Highest Salary.md
177. Nth Highest Salary.md
 
 
178. Rank Scores.md
178. Rank Scores.md
 
 
1789. Primary Department for Each Employee.md
1789. Primary Department for Each Employee.md
 
 
1795. Rearrange Products Table.md
1795. Rearrange Products Table.md
 
 
180. Consecutive Numbers.md
180. Consecutive Numbers.md
 
 
181. Employees Earning More Than Their Managers.md
181. Employees Earning More Than Their Managers.md
 
 
182. Duplicate Emails.md
182. Duplicate Emails.md
 
 
183. Customers Who Never Order.md
183. Customers Who Never Order.md
 
 
184. Department Highest Salary.md
184. Department Highest Salary.md
 
 
185. Department Top Three Salaries.md
185. Department Top Three Salaries.md
 
 
1873. Calculate Special Bonus.md
1873. Calculate Special Bonus.md
 
 
1890. The Latest Login in 2020.md
1890. The Latest Login in 2020.md
 
 
1907. Count Salary Categories.md
1907. Count Salary Categories.md
 
 
1934. Confirmation Rate.md
1934. Confirmation Rate.md
 
 
196. Delete Duplicate Emails.md
196. Delete Duplicate Emails.md
 
 
1965. Employees With Missing Information.md
1965. Employees With Missing Information.md
 
 
197. Rising Temperature.md
197. Rising Temperature.md
 
 
1978. Employees Whose Manager Left the Company.md
1978. Employees Whose Manager Left the Company.md
 
 
2356. Number of Unique Subjects Taught by Each Teacher.md
2356. Number of Unique Subjects Taught by Each Teacher.md
 
 
262. Trips and Users.md
262. Trips and Users.md
 
 
511. Game Play Analysis I.md
511. Game Play Analysis I.md
 
 
550. Game Play Analysis IV.md
550. Game Play Analysis IV.md
 
 
570. Managers with at Least 5 Direct Reports.md
570. Managers with at Least 5 Direct Reports.md
 
 
577. Employee Bonus.md
577. Employee Bonus.md
 
 
584. Find Customer Referee.md
584. Find Customer Referee.md
 
 
585. Investments in 2016.md
585. Investments in 2016.md
 
 
586. Customer Placing the Largest Number of Orders.md
586. Customer Placing the Largest Number of Orders.md
 
 
595. Big Countries.md
595. Big Countries.md
 
 
596. Classes More Than 5 Students.md
596. Classes More Than 5 Students.md
 
 
601. Human Traffic of Stadium.md
601. Human Traffic of Stadium.md
 
 
602. Friend Requests II: Who Has the Most Friends.md
602. Friend Requests II: Who Has the Most Friends.md
 
 
607. Sales Person.md
607. Sales Person.md
 
 
608. Tree Node.md
608. Tree Node.md
 
 
610. Triangle Judgement.md
610. Triangle Judgement.md
 
 
619. Biggest Single Number.md
619. Biggest Single Number.md
 
 
620. Not Boring Movies.md
620. Not Boring Movies.md
 
 
626. Exchange Seats.md
626. Exchange Seats.md
 
 
627. Swap Salary.md
627. Swap Salary.md
 
 
LICENSE
LICENSE
 
 
README.md
README.md
 
 

Repository files navigation

LeedCode Database Questions' Solutions

All Database questions' solutions in LeedCode (except for those who need subscription)

力扣所有数据库相关题目的答案

If you'd like to you can check my LeetCode profile.

Last Update on Jun 2 2024

Content

Abstract

When I got the 30 Days of Pandas badge and Top SQL 50 badge, I found my motivation and love to Database going deep further. So I push forward by finishing all database questions in LeetCode. Some of them are in Python and some of them are in SQL.

Those premiunm quentions are not include.

How do I find these questions and practice?

Go to LeetCode and click the Database button. Or just use this link.

Contribute to this repo

  • I don't know if LeetCode will add new Database questions to their problem set or not. If you find that I've missed any questions or new questions are added, feel free to contact me.
  • If you find something wrong in this repo, feel free to contact me or create an issue.

About

All Database questions' solutions in LeedCode (except for those who need subscription). 力扣所有数据库相关题目的答案（除了需要订阅的题目）

Resources

Readme

License

GPL-3.0 license
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published