Skip to content

qanhnn12/SQL-Leetcode-Challenge-Solutions

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

132 Commits
Easy
Easy
 
 
Hard
Hard
 
 
Medium
Medium
 
 
.gitattributes
.gitattributes
 
 
LICENSE
LICENSE
 
 
README.md
README.md
 
 

Repository files navigation

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

About

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

Topics

mysql sql leetcode leetcode-solutions sqlserver leetcode-sql

Resources

Readme

License

MIT license
Activity

Stars

7 stars

Watchers

2 watching

Forks

7 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages