본문 바로가기

algorithm

[HackerRank] MySQL - Weather Observation Station 1

문제

 

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;