Hackerrank | MySQL | Weather Observation Station 8

Weather Observation Station 8

• Problem

Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.

 

 

 

- Solution

 

SELECT DISTINCT CITY
FROM station
WHERE SUBSTR(CITY,1,1) IN ('a','e','i','o','u') AND CITY LIKE '%a' or
SUBSTR(CITY,1,1) IN ('a','e','i','o','u') AND CITY LIKE '%e' or
SUBSTR(CITY,1,1) IN ('a','e','i','o','u') AND CITY LIKE '%i' or
SUBSTR(CITY,1,1) IN ('a','e','i','o','u') AND CITY LIKE '%o' or
SUBSTR(CITY,1,1) IN ('a','e','i','o','u') AND CITY LIKE '%u';

SELECT DISTINCT City
FROM Station
WHERE City rlike '^[AEIOUaeiou].*[aeiou]$'

SELECT Distinct City
FROM Station
WHERE City rLike '^[aeiou]'
AND  City rLike '[aeiou]$'

SELECT DISTINCT city
FROM station
WHERE LEFT(city, 1) IN ('a','e','i','o','u')
AND right(city, 1) IN ('a','e','i','o','u')