Easy 2
Manishyadav514
mysql
4 years ago
169 B
13
Indexable
SELECT DISTINCT city FROM station
WHERE
SUBSTR(city, LENGTH(city), 1) not in ('A','E','I','O','U')
AND
SUBSTR(city, LENGTH(city),1) not in ('a','e','i','o','u'); Editor is loading...
SELECT DISTINCT city FROM station
WHERE
SUBSTR(city, LENGTH(city), 1) not in ('A','E','I','O','U')
AND
SUBSTR(city, LENGTH(city),1) not in ('a','e','i','o','u');