SQL_HACKERRANK

Basic Select Challenges

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

Advanced Select Challenges

Number	Challenges	Solutions
21	Type of Triangle	Solved SQL
22	The PADS	Solved SQL
23	New Companies	Solved SQL

Aggregation Challenges

Number	Challenges	Solutions
24	Revising Aggregations - The Count Function	Solved SQL
25	Revising Aggregations - The Sum Function	Solved SQL
26	Revising Aggregations - Averages	Solved SQL
27	Average Population	Solved SQL
28	Japan Population	Solved SQL
29	Population Density Difference	Solved SQL
30	The Blunder	Solved SQL
31	Top Earners	Solved SQL
32	Weather Observation Station 2	Solved SQL
33	Weather Observation Station 13	Solved SQL
34	Weather Observation Station 14	Solved SQL
35	Weather Observation Station 15	Solved SQL
36	Weather Observation Station 16	Solved SQL
37	Weather Observation Station 17	Solved SQL
38	Weather Observation Station 18	Solved SQL
39	Weather Observation Station 19	Solved SQL
40	Weather Observation Station 20	Solved SQL

Basic Join Challenges

Number	Challenges	Solutions
41	Population Census	Solved SQL
42	African Cities	Solved SQL
43	Average Population of Each Continent	Solved SQL

Alternative Queries Challenges

Number	Challenges	Solutions
44	Draw The Triangle 1	Solved SQL
45	Draw The Triangle 2	Solved SQL