Weather Observation Station 9
Last updated
Last updated
Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.
Sol:
SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY,1) NOT IN ('A','E','I','O','U');
Explanation:
This query retrieves distinct city names from the STATION table where the first letter of the city name is not one of the vowels 'A', 'E', 'I', 'O', or 'U'.
LEFT(CITY,1): This function extracts the leftmost character of the CITY column.
NOT IN ('A','E','I','O','U'): This condition in the WHERE clause checks if the first letter of the CITY column is not present in the specified list of vowels ('A', 'E', 'I', 'O', 'U').
So, the query selects cities where the first letter of the city name is not a vowel.
