SELECT DISTINCT (City) FROM STATION WHERE city REGEXP '^[aeiou].*[aeiou]$';

The simplest

we can do this SELECT CITY FROM STATION WHERE (SUBSTR(CITY, 1, 1) IN ('A','E','I','O','U','a','e','i','o','u')) AND (SUBSTR(CITY, LENGTH(CITY), 1) IN ('A','E','I','O','U','a','e','i','o','u'));

like this as well.but this is too much for such a simple one i guess. This work same as Right(city,1) and left(city,1)

To find unique city names in the STATION table that start and end with a vowel, you can use the following query: SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY, 1) IN ('a','i','e','o','u') AND LEFT(CITY, 1) IN ('A','E','I','O','U');

Just like this SQL query filters data with precision, professional CV writing services London UK help filter and highlight the best details of your career to make your profile stand out.

SELECT DISTINCT city FROM station WHERE city REGEXP '^[AEIOU].*[AEIOU]$'; or we can write as SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) IN ('a', 'e', 'i', 'o', 'u') AND LEFT(CITY, 1) IN ('A','E','I','O','U');

Select Distinct City from Station where left(City,1) in ("a", "e", "i", "o", "u") and right(City, 1) in ("a", "e", "i", "o", "u")