<p align="center"> <a href="https://www.hackerrank.com/riddhi0bhagat"><img src="https://cloud.githubusercontent.com/assets/19765741/25342064/d17a563c-28d8-11e7-83fc-763d4ab4820a.jpg" ></a></p>

Hackerrank Practice Problems

• This repository contains solutions to Hackerrank practice problems in SQL, C++, Java Python and Problem Solving (Data Structures and Algorithms).
• If you are interested in adding more Hackerrank problem solutions, please feel free to contribute.
• If you feel this repo is helpful for you, please do star it.
• Kindly follow CODE_OF_CONDUCT.md and CONTRIBUTING.md before contributing.
• Happy Coding 🥳!

<img src="https://img.shields.io/badge/language-MySQL-orange.svg"> <img src="https://img.shields.io/badge/language-JAVA-orange.svg"> <img src="https://img.shields.io/badge/language-C++-orange.svg"> <img src="https://img.shields.io/badge/language-Python-orange.svg"> <img src="https://img.shields.io/badge/hacktoberfest-2021-blueviolet.svg"> <img src="https://img.shields.io/badge/hacktoberfest-2022-blueviolet.svg">

Topics

<details> <summary> SQL </summary>

• Basic Select
• Advanced Select
• Aggregation
• Basic Join
• Advanced Join
• Alternative Queries

</details> <details> <summary> C++ </summary>

• Introduction
• Strings
• Classes
• STL
• Inheritance
• Debugging
• Other Concepts

</details> <details> <summary> Algorithims </summary> * [Dynamic Programming](#dynamic-programming) </details> <details> <summary> Java </summary>

• Introduction
• Strings
• BigNumber
• Data Structures
• Object Oriented Programming
• Exception Handling
• Advanced

</details> <details> <summary> Python </summary>

• Introduction
• Basic Data Types
• Strings
• Sets
• Math
• Itertools
• Collections
• Date and Time
• Errors and Exceptions
• Classes
• Built-Ins
• Python Functionals
• Regex and Parsing
• XML
• Closures and Decorators
• Numpy
• Debugging

</details>

SQL (All the solutions are given in MySQL)

Basic Select

| S.No. | Problem | Solution | Score | Difficulty | |--|--|--|--|--| | 01. | Revising the Select Query I | Solution | 10 | Easy | | 02. | Revising the Select Query II | Solution | 10 | Easy | | 03. | Select All | Solution | 10 | Easy | | 04. | Select By ID | Solution | 10 | Easy | | 05. | Japanese Cities' Attributes | Solution | 10 | Easy | | 06. | Japanese Cities' Names | Solution | 10 | Easy | | 07. | Weather Observation Station 1 | Solution | 15 | Easy | | 08. | Weather Observation Station 3 | Solution | 10 | Easy | | 09. | Weather Observation Station 4 | Solution | 10 | Easy | | 10. | Weather Observation Station 5 | Solution | 30 | Easy | | 11. | Weather Observation Station 6 | Solution | 10 | Easy | | 12. | Weather Observation Station 7 | Solution | 10 | Easy | | 13. | Weather Observation Station 8 | Solution | 15 | Easy | | 14. | Weather Observation Station 9 | Solution | 10 | Easy | | 15. | Weather Observation Station 10 | Solution | 10 | Easy | 16. | Weather Observation Station 11 | Solution | 15 | Easy | | 17. | Weather Observation Station 12 | Solution | 15 | Easy | | 18. | Higher Than 75 Marks | Solution | 15 | Easy | | 19. | Employee Names | Solution | 10 | Easy | | 20. | Employee Salaries | Solution | 10 | Easy |

Advanced Select

| S.No. | Problem | Solution | Score | Difficulty | |--|--|--|--|--| | 01. | Type of Triangle | Solution | 20 | Easy | | 02. | The PADS | Solution | 30 | Medium | | 03. | Occupations | Solution | 30 | Medium | | 04. | Binary Tree Nodes | Solution | 30 | Medium | | 05. | New Companies | Solution | 30 | Medium |

Aggregation

| S.No. | Problem | Solution | Score | Difficulty | |--|--|--|--|--| | 01. | [Revising Aggreg