This folder contains solutions to SQL challenges from HackerRank using MS SQL Server.
Here is a table of the challenges in this folder along with links to the problem and solution:
| Problem | Solution | Topic |
|---|---|---|
| Revising the Select Query I | Link | SELECT Filtering (WHERE) |
| Revising the Select Query II | Link | SELECT Filtering (WHERE) |
| Select All | Link | SELECT |
| Select By ID | Link | SELECT Filtering (WHERE) |
| Japanese Cities' Attributes | Link | SELECT Filtering (WHERE) |
| Japanese Cities' Names | Link | SELECT Filtering (WHERE) |
| Weather Observation Station 1 | Link | SELECT |
| Weather Observation Station 3 | Link | SELECT Filtering (WHERE) |
| Weather Observation Station 4 | Link | SELECT Aggregate Functions (COUNT) |
| Weather Observation Station 5 | Link | SELECT Aggregate Functions (COUNT) Sorting (ORDER BY) |
| Weather Observation Station 6 | Link | SELECT Filtering (WHERE, LIKE) |
| Weather Observation Station 7 | Link | SELECT Filtering (WHERE, LIKE) |
| Weather Observation Station 8 | Link | SELECT Filtering (WHERE, LIKE) |
| Weather Observation Station 9 | Link | SELECT Filtering (WHERE, LIKE) |
| Weather Observation Station 10 | Link | SELECT Filtering (WHERE, LIKE) |
| Weather Observation Station 11 | Link | SELECT Filtering (WHERE, LIKE) |
| Weather Observation Station 12 | Link | SELECT Filtering (WHERE, LIKE) |
| Higher Than 75 Marks | Link | SELECT Filtering (WHERE) Sorting (ORDER BY) |
| Employee Names | Link | SELECT Sorting (ORDER BY) |
| Employee Salaries | Link | SELECT Filtering (WHERE) Sorting (ORDER BY) |