Weather Observation Station 7
- URL : https://www.hackerrank.com/challenges/weather-observation-station-7/problem
- Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.
- MySQL Solution
1
2
3
4
5
6
7
select distinct(city)
from station
where (city like '%A' or
city like '%E' or
city like '%I' or
city like '%O' or
city like '%U' )