Name		Name	Last commit message	Last commit date
Latest commit History 101 Commits
1050. Actors and Directors Who Cooperated At Least Three Times.sql		1050. Actors and Directors Who Cooperated At Least Three Times.sql
1068. Product Sales Analysis I.sql		1068. Product Sales Analysis I.sql
1069. Product Sales Analysis II.sql		1069. Product Sales Analysis II.sql
1075. Project Employees I.sql		1075. Project Employees I.sql
1076. Project Employees II.sql		1076. Project Employees II.sql
1082. Sales Analysis I.sql		1082. Sales Analysis I.sql
1083. Sales Analysis II.sql		1083. Sales Analysis II.sql
1084. Sales Analysis III.sql		1084. Sales Analysis III.sql
1113. Reported Posts.sql		1113. Reported Posts.sql
1141. User Activity for the Past 30 Days I.sql		1141. User Activity for the Past 30 Days I.sql
1142. User Activity for the Past 30 Days II.sql		1142. User Activity for the Past 30 Days II.sql
1148. Article Views I.sql		1148. Article Views I.sql
1173. Immediate Food Delivery I.sql		1173. Immediate Food Delivery I.sql
1179. Reformat Department Table.sql		1179. Reformat Department Table.sql
1211. Queries Quality and Percentage.sql		1211. Queries Quality and Percentage.sql
1241. Number of Comments per Post.sql		1241. Number of Comments per Post.sql
1251. Average Selling Price. sql		1251. Average Selling Price. sql
1270. All People Report to the Given Manager.sql		1270. All People Report to the Given Manager.sql
1294. Weather Type in Each Country.sql		1294. Weather Type in Each Country.sql
1303. Find the Team Size.sql		1303. Find the Team Size.sql
1308. Running Total for Different Genders.sql		1308. Running Total for Different Genders.sql
1327. List the Products Ordered in a Period.sql		1327. List the Products Ordered in a Period.sql
1350. Students With Invalid Departments.sql		1350. Students With Invalid Departments.sql
1378. Replace Employee ID With The Unique Identifier.sql		1378. Replace Employee ID With The Unique Identifier.sql
1393. Capital Gain Loss.sql		1393. Capital Gain Loss.sql
1398. Customers Who Bought Products A and B but Not C.sql		1398. Customers Who Bought Products A and B but Not C.sql
1407. Top Travellers.sql		1407. Top Travellers.sql
1421. NPV Queries.sql		1421. NPV Queries.sql
1445. Apples & Oranges		1445. Apples & Oranges
1468. Calculate Salaries.sql		1468. Calculate Salaries.sql
1484. Group Sold Products By The Date.sql		1484. Group Sold Products By The Date.sql
1495. Friendly Movies Streamed Last Month.sql		1495. Friendly Movies Streamed Last Month.sql
1527. Patients With a Condition.sql		1527. Patients With a Condition.sql
1565. Unique Orders and Customers Per Month.sql		1565. Unique Orders and Customers Per Month.sql
1571. Warehouse Manager.sql		1571. Warehouse Manager.sql
1581. Customer Who Visited but Did Not Make Any Transactions.sql		1581. Customer Who Visited but Did Not Make Any Transactions.sql
1587. Bank Account Summary II.sql		1587. Bank Account Summary II.sql
1607. Sellers With No Sales.sql		1607. Sellers With No Sales.sql
1623. All Valid Triplets That Can Represent a Country.sql		1623. All Valid Triplets That Can Represent a Country.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
1677. Product's Worth Over Invoices.sql		1677. Product's Worth Over Invoices.sql
1683. Invalid Tweets.sql		1683. Invalid Tweets.sql
1693. Daily Leads and Partners.sql		1693. Daily Leads and Partners.sql
1709. Biggest Window Between Visits.sql		1709. Biggest Window Between Visits.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
1741. Find Total Time Spent by Each Employee1741. Find Total Time Spent by Each Employee.sql		1741. Find Total Time Spent by Each Employee1741. Find Total Time Spent by 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
176. Second Highest Salary.sql		176. Second Highest Salary.sql
177. Nth Highest Salary.sql		177. Nth Highest Salary.sql
1777. Product's Price for Each Store.sql		1777. Product's Price for Each Store.sql
178. Rank Scores.sql		178. Rank Scores.sql
1789. Primary Department for Each Employee.sql		1789. Primary Department for Each Employee.sql
1795. Rearrange Products Table.sql		1795. Rearrange Products Table.sql
180. Consecutive Numbers.sql		180. Consecutive Numbers.sql
181. Employees Earning More Than Their Managers.sql		181. Employees Earning More Than Their Managers.sql
182. Duplicate Emails.sql		182. Duplicate Emails.sql
1821. Find Customers With Positive Revenue this Year.sql		1821. Find Customers With Positive Revenue this Year.sql
183. Customers Who Never Order.sql		183. Customers Who Never Order.sql
185. Department Top Three Salaries.sql		185. Department Top Three Salaries.sql
1853. Convert Date Format.sql		1853. Convert Date Format.sql
1873. Calculate Special Bonus .sql		1873. Calculate Special Bonus .sql
1890. The Latest Login in 2020.sql		1890. The Latest Login in 2020.sql
196. Delete Duplicate Emails.sql		196. Delete Duplicate Emails.sql
511. Game Play Analysis I.sql		511. Game Play Analysis I.sql
512. Game Play Analysis II.sql		512. Game Play Analysis II.sql
534. Game Play Analysis III		534. Game Play Analysis III
577. Employee Bonus.sql		577. Employee Bonus.sql
584. Find Customer Referee.sql		584. Find Customer Referee.sql
586. Customer Placing the Largest Number of Orders.sql		586. Customer Placing the Largest Number of Orders.sql
595. Big Countries.sql		595. Big Countries.sql
596. Classes More Than 5 Students.sql		596. Classes More Than 5 Students.sql
607. Sales Person.sql		607. Sales Person.sql
610. Triangle Judgement.sql		610. Triangle Judgement.sql
613. Shortest Distance in a Line.sql		613. Shortest Distance in a Line.sql
619. Biggest Single Number.sql		619. Biggest Single Number.sql
620. Not Boring Movies.sql		620. Not Boring Movies.sql
README.md		README.md

lucius-xiao-liu/Leetcode---Database

Folders and files

Latest commit

History

Repository files navigation

Leetcode---Database

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Contributors 3

Packages