Skip to content

Latest commit

 

History

History
19 lines (12 loc) · 627 Bytes

Weather_Observation_Station_6.md

File metadata and controls

19 lines (12 loc) · 627 Bytes

Day #12 - Weather Observation Station 6

Problem

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:

1449345840-5f0a551030-Station

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

Solution

SELECT DISTINCT CITY FROM STATION
WHERE CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%';