HackerRank SQL Challenges

Description

My solutions for HackerRank SQL Challenges.

Basic Select Challenges

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

Advanced Select Challenges

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

Aggregation Challenges

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

Basic Join Challenges

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

Advance Join Challenges

Number	Challenges	Solutions
1	Placements	Solution.sql
2	Symmetric Pairs	Solution.sql

Alternative Query Challenges

Number	Challenges	Solutions
1	Draw The Triangle 1	Solution.sql
2	Draw The Triangle 2	Solution.sql
3	Print Prime Numbers	Solution.sql