Solutions for HackerRank challenges: https://www.hackerrank.com/
This repository contains 58 solutions for HackerRank practice problems with Microsoft T-SQL
Updated daily :) If it was helpful please press a star
- SQL
- Basic Select
- 001. Revising the Select Query I | Problem | Solution | Score: 10
- 002. Revising the Select Query II | Problem | Solution | Score: 10
- 003. Select All | Problem | Solution | Score: 10
- 004. Select By ID | Problem | Solution | Score: 10
- 005. Japanese Cities' Attributes | Problem | Solution | Score: 10
- 006. Japanese Cities' Names | Problem | Solution | Score: 10
- 007. Weather Observation Station 1 | Problem | Solution | Score: 15
- 008. Weather Observation Station 3 | Problem | Solution | Score: 10
- 009. Weather Observation Station 4 | Problem | Solution | Score: 10
- 010. Weather Observation Station 5 | Problem | Solution | Score: 30
- 011. Weather Observation Station 6 | Problem | Solution | Score: 10
- 012. Weather Observation Station 7 | Problem | Solution | Score: 10
- 013. Weather Observation Station 8 | Problem | Solution | Score: 15
- 014. Weather Observation Station 9 | Problem | Solution | Score: 10
- 015. Weather Observation Station 10 | Problem | Solution | Score: 10
- 016. Weather Observation Station 11 | Problem | Solution | Score: 15
- 017. Weather Observation Station 12 | Problem | Solution | Score: 15
- 018. Higher Than 75 Marks | Problem | Solution | Score: 15
- 019. Employee Names | Problem | Solution | Score: 10
- 020. Employee Salaries | Problem | Solution | Score: 10
- Advanced Select
- Aggregation
- 001. Revising Aggregations - The Count Function | Problem | Solution | Score: 10
- 002. Revising Aggregations - The Sum Function | Problem | Solution | Score: 10
- 003. Revising Aggregations - Averages | Problem | Solution | Score: 10
- 004. Average Population | Problem | Solution | Score: 10
- 005. Japan Population | Problem | Solution | Score: 10
- 006. Population Density Difference | Problem | Solution | Score: 10
- 007. The Blunder | Problem | Solution | Score: 15
- 008. Top Earners | Problem | Solution | Score: 20
- 009. Weather Observation Station 2 | Problem | Solution | Score: 15
- 010. Weather Observation Station 13 | Problem | Solution | Score: 10
- 011. Weather Observation Station 14 | Problem | Solution | Score: 10
- 012. Weather Observation Station 15 | Problem | Solution | Score: 15
- 013. Weather Observation Station 16 | Problem | Solution | Score: 10
- 014. Weather Observation Station 17 | Problem | Solution | Score: 15
- 015. Weather Observation Station 18 | Problem | Solution | Score: 25
- 016. Weather Observation Station 19 | Problem | Solution | Score: 30
- 017. Weather Observation Station 20 | Problem | Solution | Score: 40
- Basic Join
- 001. Asian Population | Problem | Solution | Score: 10
- 002. African Cities | Problem | Solution | Score: 10
- 003. Average Population of Each Continent | Problem | Solution | Score: 10
- 004. The Report | Problem | Solution | Score: 20
- 005. Top Competitors | Problem | Solution | Score: 30
- 006. Ollivander's Inventory | Problem | Solution | Score: 30
- 007. Challenges | Problem | Solution | Score: 30
- 008. Contest Leaderboard | Problem | Solution | Score: 30
- Advanced Join
- Alternative Queries
- Basic Select