Weather Observation Station 1
난이도 구분 : Easy
문제
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.
문제 풀이
station table에서 city, state만을 출력하는 단순 select 문제다.
SQL
SELECT CITY, STATE
FROM STATION