Description

The solutions to all the HackerRank SQL Track Challenges on MySQL Environment.

Domains

Basic Select

S.N.	Challenge	Solution
1.	Revising the Select Query I
2.	Revising the Select Query II
3.	Select All
4.	Stand out from the crowd
5.	Select By ID
6.	Japanese Cities' Attributes
7.	Japanese Cities' Names
8.	Weather Observation Station 1
9.	Weather Observation Station 3
10.	Weather Observation Station 4
11.	Weather Observation Station 5
12.	Weather Observation Station 6
13.	Weather Observation Station 7
14.	Weather Observation Station 8
15.	Weather Observation Station 9
16.	Weather Observation Station 10
17.	Weather Observation Station 12
18.	Higher Than 75 Marks
19.	Employee Names
20.	Employee Salaries

Advanced Select

S.N.	Challenge	Solution
1.	The PADS
2.	Occupations
3.	Binary Tree Nodes
4.	New Companies

Aggregation

S.N.	Challenge	Solution
1.	Revising Aggregations - The Sum Function
2.	Revising Aggregations - Averages
3.	Average Population
4.	Stand out from the crowd
5.	Japan Population
6.	Population Density Difference
7.	The Blunder
8.	Top Earners
9.	Weather Observation Station 2
10.	Weather Observation Station 13

Basic Join

S.N.	Challenge	Solution
1.	African Cities
2.	Average Population of Each Continent
3.	The Report
4.	Top Competitors
5.	Ollivander's Inventory
6.	Challenges
7.	Contest Leaderboard

Advanced Join

S.N.	Challenge	Solution
1.	Placements
2.	Symmetric Pairs
3.	Interviews
4.	15 Days of Learning SQL

Alternative Queries

S.N.	Challenge	Solution
1.	Draw The Triangle 2
2.	Print Prime Numbers