Skip to content

Latest commit

 

History

History
63 lines (61 loc) · 17 KB

README.md

File metadata and controls

63 lines (61 loc) · 17 KB
Raw

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