Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.
Query the list of CITY names starting with vowels (i.e., a , e , i , o , or u ) from STATION . Your result cannot contain duplicates. Input Format The STATION table is described as follows: SOLUTION : 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%'; EXPLANATION : DISTINCT : Ensures no duplicate city names are returned. SUBSTR(CITY, 1, 1) : Gets the first character of the city name. LOWER(...) : Converts the first character to lowercase for a case-insensitive comparison. IN ('a', 'e', 'i', 'o', 'u') : Filters cities that start with a vowel.