[해커랭크(HackerRank)] Weather Observation Station 1 (MySQL)

문제

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

 

풀이

Station 테이블에서 city, state 조회

 

Weather Observation Station 1 | HackerRank