반응형
Weather Observation Station 11
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'));반응형
'코딩 테스트 > SQL' 카테고리의 다른 글
| HackerRank Population Census (0) | 2023.10.30 |
|---|---|
| Weather Observation Station 12 (1) | 2023.10.29 |
| Weather Observation Station 10 (0) | 2023.10.27 |
| HeackerRank Weather Observation Station 9 (1) | 2023.10.25 |
| HeackerRank Weather Observation Station 8 (1) | 2023.10.24 |