[MYSQL] HACKERRANK - Weather Observation Station 1

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

Weather Observation Station 1 | HackerRank

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를 출력

 

코드

SELECT CITY, STATE
FROM STATION;