LeetCode-MySql-Solutions-

This repository contains python solutions for some of the LeetCode problems from the Database genre using MySql.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

LeetCode-MySql-Solutions-

About

Uh oh!

Contributors

Uh oh!

Name		Name	Last commit message	Last commit date
Latest commit History 77 Commits
1045. Customers Who Bought All Products.sql		1045. Customers Who Bought All Products.sql
1050. Actors and Directors Who Cooperated At Least Three Times.sql		1050. Actors and Directors Who Cooperated At Least Three Times.sql
1070. Product Sales Analysis III.sql		1070. Product Sales Analysis III.sql
1075. Project Employees I.sql		1075. Project Employees I.sql
1084. Sales Analysis III.sql		1084. Sales Analysis III.sql
1141. User Activity for the Past 30 Days I.sql		1141. User Activity for the Past 30 Days I.sql
1148. Article Views I.sql		1148. Article Views I.sql
1158. Market Analysis I.sql		1158. Market Analysis I.sql
1164. Product Price at a Given Date.sql		1164. Product Price at a Given Date.sql
1173. Immediate Food Delivery I.sql		1173. Immediate Food Delivery I.sql
1174. Immediate Food Delivery II.sql		1174. Immediate Food Delivery II.sql
1179. Reformat Department Table.sql		1179. Reformat Department Table.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
1393. Capital GainLoss.sql		1393. Capital GainLoss.sql
1407. Top Travellers.sql		1407. Top Travellers.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
1693. Daily Leads and Partners.sql		1693. Daily Leads and Partners.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 Employee.sql		1741. Find Total Time Spent by Each Employee.sql
175. Combine Two Tables.sql		175. Combine Two Tables.sql
176. Second Highest Salary.sql		176. Second Highest Salary.sql
177. Nth Highest Salary.sql		177. Nth Highest Salary.sql
178. Rank Scores.sql		178. Rank Scores.sql
1789. Primary Department for Each Employee.sql		1789. Primary Department for Each Employee.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
183. Customers Who Never Order.sql		183. Customers Who Never Order.sql
184. Department Highest Salary.sql		184. Department Highest Salary.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
2082. The Number of Rich Customers.sql		2082. The Number of Rich Customers.sql
2356. Number of Unique Subjects Taught by Each Teacher.sql		2356. Number of Unique Subjects Taught by Each Teacher.sql
262. Trips and Users.sql		262. Trips and Users.sql
511. Game Play Analysis I.sql		511. Game Play Analysis I.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
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
601. Human Traffic of Stadium.sql		601. Human Traffic of Stadium.sql
602. Friend Requests II Who Has the Most Friends.sql		602. Friend Requests II Who Has the Most Friends.sql
607. Sales Person.sql		607. Sales Person.sql
608. Tree Node.sql		608. Tree Node.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
627. Swap Salary.sql		627. Swap Salary.sql
README.md		README.md

Folders and files

Latest commit

History

Repository files navigation

LeetCode-MySql-Solutions-

About

Topics

Resources

Uh oh!

Stars

Watchers

Forks

Contributors

Uh oh!