az015/hackerrank

Solutions to HackerRank problems

• SQL

SQL

Subdomain	Challenge	Points	Solution
Basic Select	Revising the Select Query I	10	MySQL
Basic Select	Revising the Select Query II	10	MySQL
Basic Select	Select All	10	MySQL
Basic Select	Japanese Cities' Attributes	10	MySQL
Basic Select	Weather Observation Station 1	15	MySQL
Basic Select	Weather Observation Station 3	10	MySQL
Basic Select	Weather Observation Station 4	10	MySQL
Basic Select	Weather Observation Station 5	30	MySQL
Basic Select	Weather Observation Station 6	10	MySQL
Basic Select	Weather Observation Station 7	10	MySQL
Basic Select	Weather Observation Station 8	15	MySQL
Basic Select	Weather Observation Station 9	10	MySQL
Basic Select	Weather Observation Station 10	10	MySQL
Basic Select	Weather Observation Station 11	15	MySQL
Basic Select	Weather Observation Station 12	15	MySQL
Basic Select	Higher Than 75 Marks	15	MySQL
Basic Select	Employee Names	10	MySQL
Basic Select	Employee Salaries	10	MySQL
Basic Join	Asian Population	10	MySQL
Basic Join	African Cities	10	MySQL
Basic Join	Average Population of Each Continent	10	MySQL
Basic Join	The Report	10	MySQL
Basic Join	Top Earners	10	MySQL
Aggregation	Top Competitors	20	MySQL
Aggregation	Weather Observation Station 2	15	MySQL
Aggregation	The PADS	30	MySQL
Aggregation	Weather Observation Station 13	10	MySQL
Aggregation	Revising Aggregations - The Count	10	MySQL
Aggregation	Revising Aggregations - The Sum Function	10	MySQL
Aggregation	Revising Aggregations - Averages	10	MySQL
Aggregation	Average Population	10	MySQL
Aggregation	Japan Population	10	MySQL
Aggregation	Population Density Difference	10	MySQL
Aggregation	The Blunder	15	MySQL
Aggregation	Weather Observation Station 14	10	MySQL
Aggregation	Weather Observation Station 15	15	MySQL
Aggregation	Weather Observation Station 16	10	MySQL
Aggregation	Weather Observation Station 17	15	MySQL
Aggregation	Weather Observation Station 18	25	MySQL
Aggregation	Weather Observation Station 19	30	MySQL