Search

Weather Observation Station 11

โ€ข
์˜ค๋‹ต
SELECT DISTINCT(CITY) FROM STATION WHERE CITY NOT LIKE '[AEIOUaeiou]%' OR CITY NOT LIKE '%[AEIOUaeiou]' ;
Python
๋ณต์‚ฌ
โ€ข
์ •๋‹ต
SELECT DISTINCT(CITY) FROM STATION WHERE LEFT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U') OR RIGHT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U') ;
Python
๋ณต์‚ฌ