Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.
Input Format
The STATION table is described as follows:
where LAT_N is the northern latitude and LONG_W is the western longitude.
Weather Observation Station 7 HackerRank Solution SQL
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';
Attempt – https://www.hackerrank.com/challenges/weather-observation-station-7/
Aayush Kumar Gupta is the founder and creator of ExploringBits, a website dedicated to providing useful content for people passionate about Engineering and Technology. Aayush has completed his Bachelor of Technology (Computer Science & Engineering) from 2018-2022. From July 2022, Aayush has been working as a full-time Devops Engineer.