Hackerrank | MySQL | Weather Observation Station 12

Weather Observation Station 12

• Problem

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

 

 

- Solution

SELECT DISTINCT city
FROM station
WHERE city NOT REGEXP '^[aeiou]'
  AND city NOT REGEXP '[aeiou]$'

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