2017-04-07 20:17:38 -05:00
# SQL
2017-04-09 19:12:53 -05:00
| Subdomain | Challenge | Points | Solution |
|:-------------------:|:----------------------------------------------------------------------------------------------------------------------------:|:------:|:-----------------------------------------------------------------------------------------------------------------------------------------------------------:|
2018-07-27 16:54:21 -07:00
| 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 ) |
