Hacker Rank SQL Challenge Solutions:

1. Basic Select Subdomain

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

2. Advanced Select Subdomain

S.No	Challenge Name	Challenge	Solution
1.	Type of Triangle	Challenge	Solution
2.	The PADS	Challenge	Solution
3.	Occupations	Challenge	Solution
4.	Binary Tree Nodes	Challenge	Solution
5.	New Companies	Challenge	Solution

3. Aggregation Subdomain

S.No	Challenge Name	Challenge	Solution
1.	Revising Aggregations - The Count Function	Challenge	Solution
2.	Revising Aggregations - The Sum Function	Challenge	Solution
3.	Revising Aggregations - Averages	Challenge	Solution
4.	Average Population	Challenge	Solution
5.	Japan Population	Challenge	Solution
6.	Population Density Difference	Challenge	Solution
7.	The Blunder	Challenge	Solution
8.	Top Earners	Challenge	Solution
9.	Weather Observation Station 2	Challenge	Solution
10.	Weather Observation Station 13	Challenge	Solution
11.	Weather Observation Station 14	Challenge	Solution
12.	Weather Observation Station 15	Challenge	Solution
13.	Weather Observation Station 16	Challenge	Solution
14.	Weather Observation Station 17	Challenge	Solution
15.	Weather Observation Station 18	Challenge	Solution
16.	Weather Observation Station 19	Challenge	Solution
17.	Weather Observation Station 20	Challenge	Solution

4. Basic Join Subdomain

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

5. Advanced Join Subdomain

S.No	Challenge Name	Challenge	Solution
1.	Placements	Challenge	Solution
2.	Symmetric Pairs	Challenge	Solution
3.	Interviews	Challenge	Solution
4.	15 Days of Learning SQL	Challenge	Solution
5.	SQL Project Planning	Challenge	Solution

6. Alternative Queries Subdomain

S.No	Challenge Name	Challenge	Solution
1.	Draw The Triangle 1	Challenge	Solution
2.	Draw The Triangle 2	Challenge	Solution
3.	Print Prime Numbers	Challenge	Solution