Weather Observation Station 9

MySQL

Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:

Field

Type

ID

INTEGER

CITY

VARCHAR(21)

STATE

VARCHAR(2)

LAT_N

NUMERIC

LONG_W

NUMERIC

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

Your Logic: