Solutions to Hackerrank practice problems

This repository contains 75 solutions to Hackerrank practice problems with Python and Oracle SQL.

Updated daily :) If it was helpful please press a star.

• Algorithms
  1. Implementation
     • Electronics Shop | Problem | Solution | Score: 15
     • Cats and a Mouse | Problem | Solution | Score: 15
     • Picking Numbers | Problem | Solution | Score: 20
     • Forming a Magic Square | Problem | Solution | Score: 20
     • Climbing the Leaderboard | Problem | Solution | Score: 20
     • The Hurdle Race | Problem | Solution | Score: 15
• Data Structures
  1. Arrays
     • Arrays - DS | Problem | Solution | Score: 10
• 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
     • Nested Lists | Problem | Solution | Score: 10
     • Finding the percentage | Problem | Solution | Score: 10
  3. Strings
     • sWAP cASE | Problem | Solution | Score: 10
     • String Split and Join | Problem | Solution | Score: 10
     • What's Your Name | Problem | Solution | Score: 10
     • Mutations | Problem | Solution | Score: 10
     • Find a string | Problem | Solution | Score: 10
     • String Validators | Problem | Solution | Score: 10
     • Text Alignment | Problem | Solution | Score: 10
     • Text Wrap | Problem | Solution | Score: 10
     • Designer Door Mat | Problem | Solution | Score: 10
     • String Formatting | Problem | Solution | Score: 10
     • Capitalize! | Problem | Solution | Score: 20
  4. Itertools
     • itertoolsproduct() | Problem | Solution | Score: 10
     • itertoolscombinations() | 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
     • Binary Tree Nodes | 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
     • The Report | Problem | Solution | Score: 20
  5. Advanced Join
  6. Alternative Queries