HackerRank-SQL

HackerRank is a platform where users can practice coding skills. I finished the following problems in its SQL section. For some problems, I provided more than one solution.

Table of Content

#	Problems	Solutions	Difficulty	Tag
1	Weather Observation Station 1	Solution	Easy	Basic Select
2	Weather Observation Station 2	Solution	Easy	Aggregation
3	Weather Observation Station 3	Solution	Easy	Basic Select
4	Weather Observation Station 4	Solution	Easy	Basic Select
5	Weather Observation Station 5	Solution	Easy	Basic Select
6	Weather Observation Station 6	Solution 1, Solution 2	Easy	Basic Select
7	Weather Observation Station 7	Solution	Easy	Basic Select
8	Weather Observation Station 8	Solution	Easy	Basic Select
9	Weather Observation Station 9	Solution	Easy	Basic Select
10	Weather Observation Station 10	Solution	Easy	Basic Select
11	Weather Observation Station 11	Solution	Easy	Basic Select
12	Weather Observation Station 12	Solution	Easy	Basic Select
13	Weather Observation Station 13	Solution	Easy	Aggregation
14	Weather Observation Station 14	Solution	Easy	Aggregation
15	Weather Observation Station 15	Solution	Easy	Aggregation
16	Weather Observation Station 16	Solution	Easy	Aggregation
17	Weather Observation Station 17	Solution	Easy	Aggregation
18	Type of Triangle	Solution	Easy	Advanced Select
19	Top Earners	Solution	Easy	Aggregation
20	The Blunder	Solution	Easy	Aggregation
21	Select By ID	Solution	Easy	Basic Select
22	Select All	Solution	Easy	Basic Select
23	Revising the Select Query 1	Solution	Easy	Basic Select
24	Revising the Select Query 2	Solution	Easy	Basic Select
25	Average Population	Solution	Easy	Aggregation
26	Revising Aggregations SUM	Solution	Easy	Aggregation
27	Revising Aggregateions COUNT	Solution	Easy	Aggregation
28	Revising Aggregateions AVERAGE	Solution	Easy	Aggregation
29	Population Density Difference	Solution	Easy	Aggregation
30	Japanese Cities' Names	Solution	Easy	Basic Select
31	Japanese Cities' Attributes	Solution	Easy	Basic Select
32	Japan Population	Solution	Easy	Aggregation
33	Higher Than 75 Marks	Solution	Easy	Basic Select
34	Employee Salaries	Solution	Easy	Basic Select
35	Employee Names	Solution	Easy	Basic Select
36	Draw the Triangle 1	Solution	Easy	Alternative Queries
37	Draw the Triangle 2	Solution	Easy	Alternative Queries
38	Average Population of Each Continent	Solution	Easy	Basic Join
39	African Cities	Solution	Easy	Basic Join
40	Asian Population	Solution	Easy	Basic Join
41	The PADS	Solution	Medium	Advanced Select
42	Binary Tree Nodes	Solution	Medium	Advanced Select
43	New Companies	Solution	Medium	Advanced Select
44	The Report	Solution	Medium	Basic Join
45	Top Competitors	Solution	Medium	Basic Join
46	Ollivander's Inventory	Solution	Medium	Basic Join
47	Contest Leaderboard	Solution	Medium	Basic Join
48	SQL Project Planning	Solution	Medium	Advanced Join
49	Placements	Solution	Medium	Advanced Join
50	Weather Observation Station 18	Solution	Medium	Aggregation
51	Weather Observation Station 19	Solution	Medium	Aggregation
52	Weather Observation Station 20	Solution	Medium	Aggregation
53	Challenges	Solution	Medium	Basic Join
54	Print Prime Numbers	Solution	Medium	Alternative Queries
55	Occupations	Solution	Medium	Advanced Select
56	Symmetric Pairs	Solution	Medium	Advanced Join