Skip to content

jivan99/hackerrank-sql-solutions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Description

The solutions to all the HackerRank SQL Track Challenges on MySQL Environment.

Domains

Basic Select

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

Advanced Select

S.N. Challenge Solution
1. Type of Triangle
2. The PADS
3. Occupations
4. Binary Tree Nodes
5. New Companies

Aggregation

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

Basic Join

S.N. Challenge Solution
1. Population Census
2. African Cities
3. Average Population of Each Continent
4. The Report
5. Top Competitors
6. Ollivander's Inventory
7. Challenges
8. Contest Leaderboard

Advanced Join

S.N. Challenge Solution
1. SQL Project Planning
2. Placements
3. Symmetric Pairs
4. Interviews
5. 15 Days of Learning SQL

Alternative Queries

S.N. Challenge Solution
1. Draw The Triangle 1
2. Draw The Triangle 2
3. Print Prime Numbers

About

Solutions for HackerRank SQL Track

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published