This another problem from HackerRank called Weather Observation Station 6, Here is the SQL solution in MySQL environment.

Problem Description

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

Input Format

The STATION table is described as follows:

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

To know the details about the problem visit : Weather Observation Station 6


Please check the snippet for the sql implementation. If you have different approach in mind feel free to share in the comment below.

Originally posted at: by @Thomas-George-T