[HackerRank] MySQL : Weather Observation Station 1-5
[Weather Observation Station 1]
https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true
Weather Observation Station 1 | HackerRank
Write a query to print the CITY and STATE for each attribute in the STATION table.
www.hackerrank.com
[Problem]
[Solution]
[Weather Observation Station 3]
https://www.hackerrank.com/challenges/weather-observation-station-3/problem?isFullScreen=true
Weather Observation Station 3 | HackerRank
Query a list of unique CITY names with even ID numbers.
www.hackerrank.com
[Problem]
[Solution]
[Weather Observation Station 4]
https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true
Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
[Problem]
[Solution]
[Weather Observation Station 5]
https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true
Weather Observation Station 5 | HackerRank
Write a query to print the shortest and longest length city name along with the length of the city names.
www.hackerrank.com
[Problem]
[Example]
※ Hint
[Solution]