SQL Leetcode Challenge Solutions

Description

Solutions for all free SQL challenges on Leetcode executed on MySQL and MS SQL Server.

Questions

Number	Challenges	Solutions
1	175. Combine Two Tables	Link
2	176. Second Highest Salary	Link
3	177. Nth Highest Salary	Link
4	178. Rank Scores	Link
5	180. Consecutive Numbers	Link
6	181. Employees Earning More Than Their Managers	Link
7	182. Duplicate Emails	Link
8	183. Customers Who Never Order	Link
9	184. Department Highest Salary	Link
10	185. Department Top Three Salaries	Link
11	196. Delete Duplicate Emails	Link
12	197. Rising Temperature	Link
13	262. Trips and Users	Link
14	584. Find Customer Referee	Link
15	586. Customer Placing the Largest Number of Orders	Link
16	595. Big Countries	Link
17	Classes More Than 5 Students	Link
18	Human Traffic of Stadium	Link
19	Sales Person	Link
20	Tree Node	Link
21	Not Boring Movies	Link
22	Exchange Seats	Link
23	Swap Salary	Link
24	Actors and Directors Who Cooperated At Least Three Times	Link
25	Sales Analysis III	Link
26	Game Play Analysis I	Link
27	User Activity for the Past 30 Days I	Link
28	Article Views I	Link
29	Market Analysis I	Link
30	Reformat Department Table	Link
31	Capital Gain/Loss	Link
32	Top Travellers	Link
33	Group Sold Products By The Date	Link
34	Patients With a Condition	Link
35	Customer Who Visited but Did Not Make Any Transactions	Link
36	Bank Account Summary II	Link
37	Fix Names in a Table	[Link]
38	Daily Leads and Partners	[Link]
39	Find Followers Count	[Link]
40	Find Total Time Spent by Each Employee	[Link]
41	Recyclable and Low Fat Products	[Link]
42	Rearrange Products Table	[Link]
43	Calculate Special Bonus	[Link]
44	The Latest Login in 2020	[Link]
45	Employees With Missing Information	[Link]