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., a, e, i, o, 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
LONG_W      | NUMBER

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

Solution

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: github.com by @Thomas-George-T