Easy 2
Manishyadav514
mysql
4 years ago
169 B
7
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');