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';
from station
where city like '%a'
or
city like '%e'
or
city like '%i'
or
city like '%o'
or
city like '%u';
hackerrank: Weather Observation Station 7
I am Md Abdullah Al Hasan. I have completed my graduation in Computer Science and Engineering from Jashore University of Science and Technology.
select distinct city from station where substr(city,length(city),1) in ('a','e','i','o','u');
ReplyDelete