Hackerrank | MySQL | Weather Observation Station 9

Weather Observation Station 9

Problem

Weather Observation Station 9 | HackerRank

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

 

 

Solution

SELECT DISTINCT CITY
FROM STATION
WHERE SUBSTR(CITY, 1, 1) NOT IN ('a','e','i','o','u');

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

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