Top SQL50 Leetcode Solutions

Solutions to LeetCode Top SQL 50 study plan. Each problem links to the question and solution.

READY: MySQL 50/50, postgreSQL 18/50

Problem	MySQL	MS Server	Oracle	PostgreSQL	Pandas	Leetcode link
Select
Recyclable and Low Fat Products	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Find Customer Referee	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Big Countries	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Article Views I	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Invalid Tweets	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Basic Joins
Replace Employee ID With The Unique Identifier	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Product Sales Analysis I	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Customer Who Visited but Did Not Make Any Transactions	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Rising Temperature	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Average Time of Process per Machine	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Employee Bonus	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Students and Examinations	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Managers with at Least 5 Direct Reports	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Confirmation : Rate	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Basic Aggregate Functions
Not Boring Movies	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Average Selling Price	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Project Employees I	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Percentage of Users Attended a Contest	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Queries Quality and Percentage	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Monthly Transactions I	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Immediate Food Delivery Il	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Game Play Analysis IV	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Sorting and Grouping
Number of Unique Subjects Taught by Each Teacher	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
User Activity for the Past 30 Days I	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Product Sales Analysis III	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Classes More Than 5 Students	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Find Followers Count	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Biggest Single Number	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Customers Who Bought All Products	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Advanced Select and Joins
The Number of Employees Which Report to Each Employee	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Primary Department for Each Employee	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Triangle Judgement	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Consecutive Numbers	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Product Price at a Given Date	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Last Person to Fit in the Bus	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Count Salary Categories	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Subqueries
Employees Whose Manager Left the Company	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Exchange Seats	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Movie Rating	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Restaurant Growth	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Friend Requests II: Who Has the Most Friends	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Investments in 2016	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Department Top Three Salaries	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Advanced String Functions / Regex/Clause
Fix Names in a Table	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Patients With a Condition	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Delete Duplicate Emails	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Second Highest Salary	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Group Sold Products By The Date	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
List the Products Ordered in a Period	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
Find Users With Valid E-Mails	MySQL	MS Server	Oracle	PostgreSQL	Pandas	link
=======