HackerRank Solutions

DESCRIPTION

Compilation of solutions to HackerRank mySQL challenges; a few of the challenges included in the table remain unsolved.

CHALLENGES

Basic Select

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

Basic Join

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

Aggregation

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

Advanced Select

Number	Challenge	Solution
1	Type of Triangle	mySQL
2	Binary Tree Nodes	mySQL
3	The PADS	mySQL
4	New Companies	mySQL
5	Occupations	mySQL

Advanced Join

Number	Challenge	Solution
1	Placements	mySQL
2	Symmetric Pairs	mySQL
3	SQL Project Planning	mySQL
4	Interviews	mySQL
5	15 Days of Learning SQL	mySQL

Alternative Queries

Number	Challenge	Solution
1	Draw The Triangle 1	mySQL
2	Draw The Triangle 2	mySQL
3	Print Prime Numbers	mySQL

Credits

Code written and compiled by Iain A. Muir. Feel free to reach out to me at my University email, iam9ez@virginia.edu, if you have any questions.

README file is modeled after Thomas-George-T's repo, yet the code is my own.