HackerRank MySQL - Weather Observation Station 12
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.
- SELECT DISTINCT(CITY)
- FROM STATION
- WHERE REGEXP_LIKE(CITY, '^[^AEIOU].*[^AEIOU]$', 'i');
Please click on the like button if it worked
Solution not working or have any suggestions? Please send an email to [email protected]
