Skip to content

Latest commit

 

History

History
95 lines (80 loc) · 13.7 KB

File metadata and controls

95 lines (80 loc) · 13.7 KB

SQL HackerRank Challenge Solutions

Description

Solutions for all easy, medium and hard SQL challenges on HackerRank executed on MySQL and MS SQL Server.

Domains

Basic Select

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

Advanced Select

Number Challenges Solutions
1 Type of Triangle Link
2 The PADS Link
3 Occupations Link
4 Binary Tree Nodes Link
5 New Companies Link

Aggregation

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

Basic Join

Number Challenges Solutions
1 Population Census Link
2 African Cities Link
3 Average Population of Each Continent Link
4 The Report Link
5 Top Competitors Link
6 Ollivander's Inventory Link
7 Challenges Link
8 Contest Leaderboard Link

Advanced Join

Number Challenges Solutions
1 SQL Project Planning Link
2 Placements Link
3 Symmetric Pairs Link
4 Interviews Link
5 15 Days of Learning SQL Link

Alternative Queries

Number Challenges Solutions
1 Draw The Triangle 1 Link
2 Draw The Triangle 2 Link
3 Print Prime Numbers Link