5 lines
170 B
SQL
5 lines
170 B
SQL
SELECT DISTINCT CITY
|
|
FROM STATION
|
|
WHERE LOWER(SUBSTRING(CITY, 1, 1)) NOT IN ('a', 'e', 'i', 'o', 'u')
|
|
AND LOWER(SUBSTRING(CITY, -1, 1)) NOT IN ('a', 'e', 'i', 'o', 'u');
|