rtn Asked: October 26, 20212021-10-26T15:54:50+05:30 2021-10-26T15:54:50+05:30In: ProgrammersQuery the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.sqlsql query ending with vowels 1 AnswerVotedOldestRecent SaRa Professor 2021-10-26T16:10:11+05:30Added an answer on October 26, 2021 at 4:10 pm we can write query for this question in different ways are show below and all query’s are tested: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’;SELECT DISTINCT city FROM station WHERE city REGEXP ‘[aeiou]$’;SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP ‘[aeiouAEIOU]$’;select CITY from STATION where right(lower(CITY),1) in (‘a’,’e’,’i’,’o’,’u’) group by CITY; 0Reply Share ShareShare on FacebookShare on TwitterShare on LinkedInShare on WhatsAppLeave an answerLeave an answerCancel reply Featured image Select file Browse Add a Video to describe the problem better. Video type YoutubeVimeoDailymotionFacebook Choose from here the video type. Video ID Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs". Answer Anonymously Save my name, email, and website in this browser for the next time I comment. Related Questions Which operator is used to compare the NULL values in SQL? Which of the following is the correct order of a SQL statement? Which command is used to change the definition of a table in SQL? In which of the following cases a DML statement is not executed? Which of the following is a legal expression in SQl? Which of the following is not a valid aggregate function SQL? Which of the following is valid SQL for an index?