Weather Observation Station 1

MySQL

Query a list of CITY and STATE from the STATION table. The STATION table is described as follows:

Field

Type

ID

INT

CITY

VARCHAR(21)

STATE

VARCHAR(2)

LAN_N

NUMERIC

LONG_W

NUMERIC

where LAT_N is the northern latitude and LONG_W is the western longitude.

Your Logic: