列表如下

SELECT CITY FROM STATION
WHERE SUBSTR(CITY, 1,1) NOT IN (‘A‘,‘E‘,‘I‘,‘O‘,‘U‘)
GROUP BY CITY;

sql 查询city名字开头不含元音字母