/HackerRank-solutions-SQL

Welcome to the HackerRank SQL Solutions Repository! This repository contains my solutions to various SQL challenges from HackerRank.

MIT LicenseMIT

HackerRank logo

Solutions to HackerRank challenges

This repository is a collection of updated solutions to programming challenges on HackerRank.

SQL / MySQL

I have used MYSQL for the solutions. There are almost always multiple solutions to the same problem. I have tried including alternate solutions whenever possible.

Basic Select

Challenge Score Solution
Revising the Select Query I 10 Solution
Revising the Select Query II 10 Solution
Select All 10 Solution
Select By ID 10 Solution
Japanese Cities' Attributes 10 Solution
Japanese Cities' Names 10 Solution
Weather Observation Station 1 15 Solution
Weather Observation Station 3 10 Solution
Weather Observation Station 4 10 Solution
Weather Observation Station 5 30 Solution
Weather Observation Station 6 10 Solution
Weather Observation Station 7 10 Solution
Weather Observation Station 8 15 Solution
Weather Observation Station 9 10 Solution
Weather Observation Station 10 10 Solution
Weather Observation Station 11 15 Solution
Weather Observation Station 12 15 Solution
Higher Than 75 Marks 15 Solution
Employee Names 10 Solution
Employee Salaries 10 Solution

Advanced Select

Challenge Score Solution
Type of Triangle 20 Solution
The PADS 30 Solution
Occupations 30 Solution
Binary Tree Nodes 30 Solution
New Companies 30 Solution

Aggregation

Challenge Score Solution
Revising Aggregations - The Count Function 10 Solution
Revising Aggregations - The Sum Function 10 Solution
Revising Aggregations - Averages 10 Solution
Average Population 10 Solution
Japan Population 10 Solution
Population Density Difference 10 Solution
The Blunder 15 Solution
Top Earners 20 Solution
Weather Observation Station 2 15 Solution
Weather Observation Station 13 10 Solution
Weather Observation Station 14 10 Solution
Weather Observation Station 15 15 Solution
Weather Observation Station 16 10 Solution
Weather Observation Station 17 15 Solution
Weather Observation Station 18 25 Solution
Weather Observation Station 19 30 Solution
Weather Observation Station 20 40 Solution

Basic Join

Challenge Score Solution
Asian Population 10 Solution
African Cities 10 Solution
Average Population of Each Continent 10 Solution
The Report 20 Solution
Top Competitors 30 Solution
Ollivander's Inventory 30 Solution
Challenges 30 Solution
Contest Leaderboard 30 Solution

Advanced Join

Challenge Score Solution
SQL Project Planning 40 Solution
Placements 40 Solution
Symmetric Pairs 40 Solution
Interviews 50 Solution
15 Days of Learning SQL 50 Solution

Alternative Queries

Challenge Score Solution
Draw The Triangle 1 25 Solution
Draw The Triangle 2 25 Solution
Print Prime Numbers 40 Solution

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Contact me

Feel free to connect with me on LinkedIn: Reyas Khan

If you have any questions, doubts, or would like to discuss anything related to this Challenge, don't hesitate to reach out! I'm always happy to help.

Happy learning

HackerRank-solutions-SQL