Query city and state from STATION
Author: Al-mamun Sarkar
Date: 2020-03-27 19:37:27
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;