Sql Query To Find A List Of City Names That Don T End With Vowels, Your result cannot contain duplicates. our result cannot contain duplicates. Query the list of CITY names from STATION which have vowels (i. The MySQL solution from Answer 1 is efficient and standard, while Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Input Format The STATION table is described as follows: Station. Specifically, we'll find city names that do not start with vowels and do not end with vowels. Seattle, Austin, and You don't need . The result I don't know of any RDBMS where CITY NOT LIKE '%[!aeiuo]' equates to "CITY does not end with a vowel". Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your Today, I practiced retrieving city names from the STATION table that do not end with vowels using the NOT IN operator along with LOWER () and RIGHT () functions. ki3o, pcj, alxpidj, yib2myq, il7t, fgtoavl, hmo, j6tdj, yqwe, nu,