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

Problem

HackerRank > Prepare > SQL > Basic Select > 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.

Solution

SELECT DISTINCT CITY, STATE
FROM STATION
;