Weather Observation Station 1: HackerRank

Query a list of CITY and STATE from the STATION table.

Input Format The STATION table is described as follows:

Solution:

select CITY,STATE from STATION order by CITY,STATE;