In this repository you will find my answers to the SQL challenges proposed in HackerRank, from basic to advanced level.
Listed below are the questions available in this repository. Each link leads to the document containing both, the question statement and the answer, written in MS SQL Server (except for two short problems that were written in pl/sql).
- The pads
- Revising Aggregations - The Count Function
- Revising Aggregations - The Sum Function
- Revising Aggregations - Averages
- Average Population
- Japan Population
- Population Density Difference
- The Blunder
- Top Earners
- Weather Observation Station 2
- Weather Observation Station 13
- Weather Observation Station 14
- Weather Observation Station 15
- Weather Observation Station 16
- Weather Observation Station 17
- Weather Observation Station 18
- Weather Observation Station 19
- Average Population of Each Continent
- Binary tree nodes
- Challenges
- Contest leaderboard
- Interviews
- Ollivander's inventory
- Placements
- SQL Project planning
- Symmetric pairs
- The report
- Top competitors
- Weather Observation Station 20
- 15 Days of Learning SQL
- Draw the triangle 1 [PL/SQL]
- Draw the triangle 2 [PL/SQL]
- Print prime numbers
If you have any feedback, please reach out to me at martacasdelg@gmail.com
