Skip to content

Latest commit

 

History

History
19 lines (13 loc) · 569 Bytes

File metadata and controls

19 lines (13 loc) · 569 Bytes

Challenge 17 - Weather observation station 11

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

The STATION table is described as follows:

Field Type
ID NUMBER
CITY VARCHAR2(21)
STATE VARCHAR2(2)
LAT_N NUMBER
LONG_W NUMBER

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

Solutions