HackerRank-SQL-Challenges-Solutions
HackerRank-SQL-Challenges-Solutions copied to clipboard
Published
20 hours ago •
Thomas-George-T
Thomas-George-T
The solutions of all SQL hackerrank challenges using MySQL environment
Description
The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges.
Domains
Basic Select Challenges
| Number | Challenges | Solutions |
|---|---|---|
| 1 | Revising the Select Query I | SQL |
| 2 | Revising the Select Query II | SQL |
| 3 | Select All | SQL |
| 4 | Select By ID | SQL |
| 5 | Japanese Cities' Attributes | SQL |
| 6 | Japanese Cities' Names | SQL |
| 7 | Weather Observation Station 1 | SQL |
| 8 | Weather Observation Station 3 | SQL |
| 9 | Weather Observation Station 4 | SQL |
| 10 | Weather Observation Station 5 | SQL |
| 11 | Weather Observation Station 6 | SQL |
| 12 | Weather Observation Station 7 | SQL |
| 13 | Weather Observation Station 8 | SQL |
| 14 | Weather Observation Station 9 | SQL |
| 15 | Weather Observation Station 10 | SQL |
| 16 | Weather Observation Station 11 | SQL |
| 17 | Weather Observation Station 12 | SQL |
| 18 | Higher Than 75 Marks | SQL |
| 19 | Employee Names | SQL |
| 20 | Employee Salaries | SQL |
Advanced Select Challenges
| Number | Challenges | Solutions |
|---|---|---|
| 1 | Type of Triangle | SQL |
| 2 | The PADS | SQL |
| 3 | Occupations | SQL |
| 4 | Binary Tree Nodes | SQL |
| 5 | New Companies | SQL |
Aggregation Challenges
| Number | Challenges | Solutions |
|---|---|---|
| 1 | Revising Aggregations - The Count Function | SQL |
| 2 | Revising Aggregations - The Sum Function | SQL |
| 3 | Revising Aggregations - Averages | SQL |
| 4 | Average Population | SQL |
| 5 | Japan Population | SQL |
| 6 | Population Density Difference | SQL |
| 7 | The Blunder | SQL |
| 8 | Top Earners | SQL |
| 9 | Weather Observation Station 2 | SQL |
| 10 | Weather Observation Station 13 | SQL |
| 11 | Weather Observation Station 14 | SQL |
| 12 | Weather Observation Station 15 | SQL |
| 13 | Weather Observation Station 16 | SQL |
| 14 | Weather Observation Station 17 | SQL |
| 15 | Weather Observation Station 18 | SQL |
| 16 | Weather Observation Station 19 | SQL |
| 17 | Weather Observation Station 20 | SQL |
Basic Join
| Number | Challenges | Solutions |
|---|---|---|
| 1 | Asian Population | SQL |
| 2 | African Cities | SQL |
| 3 | Average Population of Each Continent | SQL |
| 4 | The Report | SQL |
| 5 | Top Competitors | SQL |
| 6 | Ollivander's Inventory | SQL |
| 7 | Challenges | SQL |
| 8 | Contest Leaderboard | SQL |
Advanced Join
| Number | Challenges | Solutions |
|---|---|---|
| 1 | SQL Project Planning | SQL |
| 2 | Placements | SQL |
References
Features & Mentions
This project was featured in laptrinhx. Thank you for the listing!
License
This repository is licensed under MIT License - see License for more details
Metadata
679
Stars
200
Forks
Watchers
Owner
Thomas-George-T
Metadata
The solutions of all SQL hackerrank challenges using MySQL environment