HackerRank MySQL - Weather Observation Station 10
Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.
- SELECT DISTINCT CITY
- FROM STATION
- WHERE REGEXP_LIKE(CITY, '[^aeiou]$');
Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.
- SELECT DISTINCT CITY
- FROM STATION
- WHERE REGEXP_LIKE(CITY, '[^aeiou]$');
Codesadda.com is your home of programming solutions, tutorials, video tutorials and much more. Sign Up for our weekly newsletter to get update about new content.