The compiled solutions encompass all SQL challenges, ranging from Easy to Hard, on HackerRank. These solutions were executed in a MySQL environment.
In the below table, the columns indicate the following attributes related to the weekly challenge:
-
ID : Identity column for individual challenge.
-
Challenges : Link to the SQL questions hosted on HackerRank.
-
Difficulty : Difficulty level of the SQL challenge.
-
Solution Script : Link to the solution SQL script hosted in this repository.
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Revising the Select Query I | 🟢 | Solution |
| 2 | Revising the Select Query II | 🟢 | Solution |
| 3 | Select All | 🟢 | Solution |
| 4 | Select By ID | 🟢 | Solution |
| 5 | Japanese Cities' Attributes | 🟢 | Solution |
| 6 | Japanese Cities' Ns | 🟢 | Solution |
| 7 | Weather Observation Station 1 | 🟢 | Solution |
| 8 | Weather Observation Station 3 | 🟢 | Solution |
| 9 | Weather Observation Station 4 | 🟢 | Solution |
| 10 | Weather Observation Station 5 | 🟢 | Solution |
| 11 | Weather Observation Station 6 | 🟢 | Solution |
| 12 | Weather Observation Station 7 | 🟢 | Solution |
| 13 | Weather Observation Station 8 | 🟢 | Solution |
| 14 | Weather Observation Station 9 | 🟢 | Solution |
| 15 | Weather Observation Station 10 | 🟢 | Solution |
| 16 | Weather Observation Station 11 | 🟢 | Solution |
| 17 | Weather Observation Station 12 | 🟢 | Solution |
| 18 | Higher Than 75 Marks | 🟢 | Solution |
| 19 | Employee Names | 🟢 | Solution |
| 20 | Employee Salaries | 🟢 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Type of Triangle | 🟢 | Solution |
| 2 | The PADS | 🟡 | Solution |
| 3 | Occupations | 🟡 | Solution |
| 4 | Binary Tree Nodes | 🟡 | Solution |
| 5 | New Companies | 🟡 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Population Consensus | 🟢 | Solution |
| 2 | African Cities | 🟢 | Solution |
| 3 | Average Population of Each Continent | 🟢 | Solution |
| 4 | The Report | 🟡 | Solution |
| 5 | Top Competitors | 🟡 | Solution |
| 6 | Ollivander's Inventory | 🟡 | Solution |
| 7 | Challenges | 🟡 | Solution |
| 8 | Contest Leaderboard | 🟡 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | SQL Project Planning | 🟡 | Solution |
| 2 | Placements | 🟡 | Solution |
| 3 | Symmetric Pairs | 🟡 | Solution |
| 4 | Interviews | 🔴 | Solution |
| 5 | 15 Days of Learning SQL | 🔴 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Draw the Triangle 1 | 🟢 | Solution |
| 2 | Draw the Triangle 2 | 🟢 | Solution |
| 3 | Print Prime Numbers | 🟡 | Solution |
Contributions are always welcome !!
If you would like to contribute to the project, please fork the repository and make a pull request.
If you have any doubts, queries or, suggestions then, please connect with me on LinkedIn.
Do ⭐ the repository, if it inspired you, gave you ideas of your own or helped you in any way !!