SQL-Challenges-Solutions

Description

The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank and LeetCode executed on MySQL environment compiled with helpful Resources & references related to the challenges.

Domains

Basic Select Challenges

Number	Challenges	Solutions
1	Select All	SQL
2	Weather Observation Station 1	SQL
3	Revising the Select Query I	SQL
4	Revising the Select Query II	SQL
5	Weather Observation Station 6	SQL
6	Select By ID	SQL
7	Weather Observation Station 12	SQL
8	Employee Names	SQL
9	Employee Salaries	SQL
10	Higher Than 75 Marks	SQL
11	Weather Observation Station 4	SQL
12	Challenges	SQL
14	Weather Observation Station 7	SQL
15	Weather Observation Station 8	SQL
16	Weather Observation Station 9	SQL
17	Weather Observation Station 5	SQL
18	Weather Observation Station 10	SQL
19	Weather Observation Station 11	SQL

Aggregation

Number	Challenges	Solutions
1	Weather Observation Station 15	SQL
2	Japanese Cities' Attributes	SQL
3	Japanese Cities' Names	SQL
4	Weather Observation Station 3	SQL
5	Weather Observation Station 4	SQL
6	Revising Aggregation-Averages	SQL
7	Revising Aggregation-The Count Function	SQL
8	Average Population	SQL
9	Population Density Difference	SQL
10	Top Earners	SQL
11	Revising Aggregations - The Sum Function	SQL
12	Japan Population	SQL
13	The Blunder	SQL
14	Weather Observation Station 2	SQL
15	Weather Observation Station 13	SQL
16	Weather Observation Station 14	SQL
17	Weather Observation Station 16	SQL
18	Weather Observation Station 17	SQL
19	Weather Observation Station 18	SQL
20	Weather Observation Station 19	SQL
21	Weather Observation Station 20	SQL

Advanced Select

Number	Challenges	Solutions
1	Type of Triangle	SQL
2	Binary Tree Nodes	SQL
3	The PADS	SQL
4	Occupations	SQL
5	New Companies	SQL

Basic Join

Number	Challenges	Solutions
1	African Cities	SQL
2	Popular Census	SQL
3	Top Competitors	SQL
4	Average Population of Each Continent	SQL
5	The Report	SQL
6	Contest Leaderboard	SQL

Advanced Join

Number	Challenges	Solutions
1	Placements	SQL

LeetCode

Number	Challenges	Solutions
1	1179.Reformat Department Table	SQL
2	183.Customer Who Never Order	SQL
3	181.Employees Earning More Than Their Managers	SQL
4	197.Rising Temperature	SQL
5	627.Swap Salary	SQL
6	196.Delete Duplicate Emails	SQL
7	184.Department Highest Salary	SQL
8	190.Consecutive Numbers	SQL
9	185.Department Top Three Salaries	SQL
10	177.Nth Highest Salary	SQL
11	595.Big Countries	SQL
12	620.Not Boring Movies	SQL
13	175.Combine Two Tables	SQL
14	596.Classes More Than 5 Students	SQL
15	176.Second Highest Salary	SQL
16	1407.Top Travellers	SQL
17	1527.Patients With a Condition	SQL
18	1667.Fix Names in a Table	SQL
19	1084. Sales Analysis III	SQL
20	511. Game Play Analysis I	SQL
21	1795. Rearrange Products Table	SQL
22	1693. Daily Leads and Partners	SQL
23	1581. Customer Who Visited but Did Not Make Any Transactions	SQL
24	1587. Bank Account Summary II	SQL
25	584. Find Customer Referee	SQL
26	586. Customer Placing the Largest Number of Orders	SQL
27	1729. Find Followers Count	SQL
28	1484. Group Sold Products By The Date	SQL