Solutions to HackerRank practice problems

This repository contains 54 solutions to HackerRank practice problems with Python 3 and SQL (MySQL).

Updated daily 😃. If you found it helpful please press ⭐.

• Python
  1. Introduction
     • Say Hello, World! With Python | Problem | Solution | Score: 5
     • Python If-Else | Problem | Solution | Score: 10
     • Arithmetic Operators | Problem | Solution | Score: 10
     • Python Division | Problem | Solution | Score: 10
     • Loops | Problem | Solution | Score: 10
     • Write a function | Problem | Solution | Score: 10
     • Print Function | Problem | Solution | Score: 20
  2. Basic Data Types
     • List Comprehensions | Problem | Solution | Score: 10
     • Find the Runner-Up Score! | Problem | Solution | Score: 10
• SQL
  1. Basic Select
     • Revising the Select Query I | Problem | Solution | Score: 10
     • Revising the Select Query II | Problem | Solution | Score: 10
     • Select All | Problem | Solution | Score: 10
     • Select By ID | Problem | Solution | Score: 10
     • Japanese Cities' Attributes | Problem | Solution | Score: 10
     • Japanese Cities' Names | Problem | Solution | Score: 10
     • Weather Observation Station 1 | Problem | Solution | Score: 15
     • Weather Observation Station 3 | Problem | Solution | Score: 10
     • Weather Observation Station 4 | Problem | Solution | Score: 10
     • Weather Observation Station 5 | Problem | Solution | Score: 30
     • Weather Observation Station 6 | Problem | Solution | Score: 10
     • Weather Observation Station 7 | Problem | Solution | Score: 10
     • Weather Observation Station 8 | Problem | Solution | Score: 15
     • Weather Observation Station 9 | Problem | Solution | Score: 10
     • Weather Observation Station 10 | Problem | Solution | Score: 10
     • Weather Observation Station 11 | Problem | Solution | Score: 15
     • Weather Observation Station 12 | Problem | Solution | Score: 15
     • Higher Than 75 Marks | Problem | Solution | Score: 15
     • Employee Names | Problem | Solution | Score: 10
     • Employee Salaries | Problem | Solution | Score: 10
  2. Advanced Select
     • Type of Triangle | Problem | Solution | Score: 20
     • The PADS | Problem | Solution | Score: 30
     • Occupations | Problem | Solution | Score: 30
     • Binary Tree Nodes | Problem | Solution | Score: 30
     • New Companies | Problem | Solution | Score: 30
  3. Aggregation
     • Revising Aggregations - The Count Function | Problem | Solution | Score: 10
     • Revising Aggregations - The Sum Function | Problem | Solution | Score: 10
     • Revising Aggregations - Averages | Problem | Solution | Score: 10
     • Average Population | Problem | Solution | Score: 10
     • Japan Population | Problem | Solution | Score: 10
     • Population Density Difference | Problem | Solution | Score: 10
     • The Blunder | Problem | Solution | Score: 15
     • Top Earners | Problem | Solution | Score: 20
     • Weather Observation Station 2 | Problem | Solution | Score: 15
     • Weather Observation Station 13 | Problem | Solution | Score: 10
     • Weather Observation Station 14 | Problem | Solution | Score: 10
     • Weather Observation Station 15 | Problem | Solution | Score: 15
     • Weather Observation Station 16 | Problem | Solution | Score: 10
     • Weather Observation Station 17 | Problem | Solution | Score: 15
     • Weather Observation Station 18 | Problem | Solution | Score: 25
     • Weather Observation Station 19 | Problem | Solution | Score: 30
     • Weather Observation Station 20 | Problem | Solution | Score: 40
  4. Basic Join
     • Asian Population | Problem | Solution | Score: 10
     • African Cities | Problem | Solution | Score: 10
     • Average Population of Each Continent | Problem | Solution | Score: 10
  5. Advanced Join
  6. Alternative Queries

Courtesy

Alexander Marinskiy

License

MIT

Author Information

This repository was created in 2018 by Md Robaiatul Islam.