SQL Leetcode Challenge Solutions

Description

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

Questions

Easy

Number	Challenges	Solutions
1	175. Combine Two Tables	Link
2	176. Second Highest Salary	Link
3	181. Employees Earning More Than Their Managers	Link
4	182. Duplicate Emails	Link
5	183. Customers Who Never Order	Link
6	196. Delete Duplicate Emails	Link
7	197. Rising Temperature	Link
8	511. Game Play Analysis I	Link
9	584. Find Customer Referee	Link
10	586. Customer Placing the Largest Number of Orders	Link
11	595. Big Countries	Link
12	596. Classes More Than 5 Students	Link
13	607. Sales Person	Link
14	620. Not Boring Movies	Link
15	627. Swap Salary	Link
16	1050. Actors and Directors Who Cooperated At Least Three Times	Link
17	1084. Sales Analysis III	Link
18	1141. User Activity for the Past 30 Days I	Link
19	1148. Article Views I	Link
20	1179. Reformat Department Table	Link
21	1407. Top Travellers	Link
22	1484. Group Sold Products By The Date	Link
23	1527. Patients With a Condition	Link
24	1581. Customer Who Visited but Did Not Make Any Transactions	Link
25	1587. Bank Account Summary II	Link
26	1667. Fix Names in a Table	Link
27	1693. Daily Leads and Partners	Link
28	1729. Find Followers Count	Link
29	1741. Find Total Time Spent by Each Employee	Link
30	1757. Recyclable and Low Fat Products	Link
31	1795. Rearrange Products Table	Link
32	1873. Calculate Special Bonus	Link
33	1890. The Latest Login in 2020	Link
34	1965. Employees With Missing Information	Link

Medium

Number	Challenges	Solutions
1	177. Nth Highest Salary	Link
2	178. Rank Scores	Link
3	180. Consecutive Numbers	Link
4	184. Department Highest Salary	Link
5	608. Tree Node	Link
6	626. Exchange Seats	Link
7	1158. Market Analysis I	Link
8	1393. Capital Gain/Loss	Link

Hard

Number	Challenges	Solutions
1	185. Department Top Three Salaries	Link
2	262. Trips and Users	Link
3	601. Human Traffic of Stadium	Link