Query city and state from STATION

Query all cities and states from the STATION table. This is the solution of HackerRank's Weather Observation Station 1 SQL problem.

Table name: STATION

Table Structure:

Fileds	Type
ID	NUMBER
CITY	VARCHAR
STATE	VARCHAR
LAT_N	NUMBER
LONG_W	NUMBER

 

SQL Query:

SELECT CITY, STATE FROM STATION;