# SQL | Subdomain | Challenge | Points | Solution | |:-------------------:|:----------------------------------------------------------------------------------------------------------------------------:|:------:|:-----------------------------------------------------------------------------------------------------------------------------------------------------------:| | Basic Select | [Revising the Select Query I](https://www.hackerrank.com/challenges/revising-the-select-query) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Revising%20the%20Select%20Query%20I.sql) | | Basic Select | [Revising the Select Query II](https://www.hackerrank.com/challenges/revising-the-select-query-2) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Revising%20the%20Select%20Query%20II.sql) | | Basic Select | [Select All](https://www.hackerrank.com/challenges/select-all-sql) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Select%20All.sql) | | Basic Select | [Select By ID](https://www.hackerrank.com/challenges/select-by-id) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Select%20By%20ID.sql) | | Basic Select | [Japanese Cities' Attributes](https://www.hackerrank.com/challenges/japanese-cities-attributes) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Japanese%20Cities%27%20Attributes.sql) | | Basic Select | [Japanese Cities' Names](https://www.hackerrank.com/challenges/japanese-cities-name) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Japanese%20Cities%27%20Names.sql) | | Basic Select | [Weather Observation Station 1](https://www.hackerrank.com/challenges/weather-observation-station-1) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%201.sql) | | Basic Select | [Weather Observation Station 3](https://www.hackerrank.com/challenges/weather-observation-station-3) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%203.sql) | | Basic Select | [Weather Observation Station 4](https://www.hackerrank.com/challenges/weather-observation-station-4) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%204.sql) | | Basic Select | [Weather Observation Station 5](https://www.hackerrank.com/challenges/weather-observation-station-5) | 30 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%205.sql) | | Basic Select | [Weather Observation Station 6](https://www.hackerrank.com/challenges/weather-observation-station-6) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%206.sql) | | Basic Select | [Weather Observation Station 7](https://www.hackerrank.com/challenges/weather-observation-station-7) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%207.sql) | | Basic Select | [Weather Observation Station 8](https://www.hackerrank.com/challenges/weather-observation-station-8) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%208.sql) | | Basic Select | [Weather Observation Station 9](https://www.hackerrank.com/challenges/weather-observation-station-9) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%209.sql) | | Basic Select | [Weather Observation Station 10](https://www.hackerrank.com/challenges/weather-observation-station-10) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%2010.sql) | | Basic Select | [Weather Observation Station 11](https://www.hackerrank.com/challenges/weather-observation-station-11) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%2011.sql) | | Basic Select | [Weather Observation Station 12](https://www.hackerrank.com/challenges/weather-observation-station-12) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Weather%20Observation%20Station%2012.sql) | | Basic Select | [Higher Than 75 Marks](https://www.hackerrank.com/challenges/more-than-75-marks) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Higher%20Than%2075%20Marks.sql) | | Basic Select | [Employee Names](https://www.hackerrank.com/challenges/name-of-employees) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Employee%20Names.sql) | | Basic Select | [Employee Salaries](https://www.hackerrank.com/challenges/salary-of-employees) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Select/Employee%20Salaries.sql) | | Basic Join | [Asian Population](https://www.hackerrank.com/challenges/asian-population) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Join/Asian%20Population.sql) | | Basic Join | [African Cities](https://www.hackerrank.com/challenges/african-cities) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Join/African%20Cities.sql) | | Basic Join | [Average Population of Each Continent](https://www.hackerrank.com/challenges/average-population-of-each-continent) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Join/Average%20Population%20of%20Each%20Continent.sql) | | Basic Join | [The Report](https://www.hackerrank.com/challenges/the-report) | 20 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Basic%20Join/The%20Report.sql) | | Aggregation | [Revising Aggregations - The Count Function](https://www.hackerrank.com/challenges/revising-aggregations-the-count-function) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Revising%20Aggregations%20-%20The%20Count%20Function.sql) | | Aggregation | [Revising Aggregations - The Sum Function](https://www.hackerrank.com/challenges/revising-aggregations-sum) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Revising%20Aggregations%20-%20The%20Sum%20Function.sql) | | Aggregation | [Revising Aggregations - Averages](https://www.hackerrank.com/challenges/revising-aggregations-the-average-function) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Revising%20Aggregations%20-%20Averages.sql) | | Aggregation | [Average Population](https://www.hackerrank.com/challenges/average-population) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Average%20Population.sql) | | Aggregation | [Japan Population](https://www.hackerrank.com/challenges/japan-population) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Japan%20Population.sql) | | Aggregation | [Population Density Difference](https://www.hackerrank.com/challenges/population-density-difference) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Population%20Density%20Difference.sql) | | Aggregation | [The Blunder](https://www.hackerrank.com/challenges/the-blunder) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/The%20Blunder.sql) | | Aggregation | [Top Earners](https://www.hackerrank.com/challenges/earnings-of-employees) | 20 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Top%20Earners.sql) | | Aggregation | [Weather Observation Station 2](https://www.hackerrank.com/challenges/weather-observation-station-2) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%202.sql) | | Aggregation | [Weather Observation Station 13](https://www.hackerrank.com/challenges/weather-observation-station-13) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%2013.sql) | | Aggregation | [Weather Observation Station 14](https://www.hackerrank.com/challenges/weather-observation-station-14) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%2014.sql) | | Aggregation | [Weather Observation Station 15](https://www.hackerrank.com/challenges/weather-observation-station-15) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%2015.sql) | | Aggregation | [Weather Observation Station 16](https://www.hackerrank.com/challenges/weather-observation-station-16) | 10 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%2016.sql) | | Aggregation | [Weather Observation Station 17](https://www.hackerrank.com/challenges/weather-observation-station-17) | 15 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%2017.sql) | | Aggregation | [Weather Observation Station 18](https://www.hackerrank.com/challenges/weather-observation-station-18) | 25 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%2018.sql) | | Aggregation | [Weather Observation Station 19](https://www.hackerrank.com/challenges/weather-observation-station-19) | 30 | [MySQL Solution](https://github.com/RodneyShag/HackerRank_solutions/blob/master/SQL/Aggregation/Weather%20Observation%20Station%2019.sql) |