HackerRank-SQL_Solutions

Description

The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment.

Domains

Basic Select Challenges

Number	Challenges	Solution
1	Employee Names	Click Here
2	Employee Salaries	Click Here
3	Higher Than 75 Marks	Click Here
4	Japanese Cities' Attributes	Click Here
5	Japanese Cities' Names.sql	Click Here
6	Revising the Select Query - 1	Click Here
7	Revising the Select Query - 2	Click Here
8	Select All	Click Here
9	Select by ID	Click Here
10	Weather Observation Station 1	Click Here
11	Weather Observation Station 3	Click Here
12	Weather Observation Station 4	Click Here
13	Weather Observation Station 5	Click Here
14	Weather Observation Station 6	Click Here
15	Weather Observation Station 7	Click Here
16	Weather Observation Station 8	Click Here
17	Weather Observation Station 9	Click Here

Basic Join

Number	Challenges	Solution
1	African Cities	Click Here
2	Average Population of Each Continent	Click Here
3	Population Census	Click Here
4	The Report	Click Here

Aggregation Challenges

Number	Challenges	Solution
1	Average_Population	Click Here
2	Japan_Population	Click Here
3	Population Density Difference	Click Here
4	Revising Aggregations - Averages	Click Here
5	Revising Aggregations - The Count Function	Click Here
6	Revising Aggregations - The Sum Function	Click Here
7	The Blunder	Click Here
8	Top Earners	Click Here
9	Weather Observation Station 13	Click Here
10	Weather Observation Station 14	Click Here
11	Weather Observation Station 15	Click Here
12	Weather Observation Station 16	Click Here
13	Weather Observation Station 17	Click Here
14	Weather Observation Station 18	Click Here
15	Weather Observation Station 19	Click Here
16	Weather Observation Station 2	Click Here
17	Weather Observation Station 20	Click Here

Advanced Select Challenges