[MySQL/HackerRank] Weather Observation Station 1

Question

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.

 

My Answer

SELECT CITY, STATE
FROM STATION;

Result

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

Weather Observation Station 1 | HackerRank