[MySQL] HackerRank - Weather Observation Station 1

문제

https://www.hackerrank.com/challenges/weather-observation-station-1/problem

Weather Observation Station 1 | HackerRank

Query a list of CITY and STATE from the STATION table. The STATION table is described as follows:

Where LAT_N is the northern latitude and LONG_W is the western longitude.

 

정답

SELECT CITY, STATE 
FROM STATION