반응형
Weather Observation Station 10
SELECT DISTINCT CITY
FROM STATION
WHERE CITY NOT LIKE '%a'
AND CITY NOT LIKE '%e'
AND CITY NOT LIKE '%i'
AND CITY NOT LIKE '%o'
AND CITY NOT LIKE '%u';반응형
'코딩 테스트 > SQL' 카테고리의 다른 글
| Weather Observation Station 12 (1) | 2023.10.29 |
|---|---|
| Weather Observation Station 11 (1) | 2023.10.28 |
| HeackerRank Weather Observation Station 9 (1) | 2023.10.25 |
| HeackerRank Weather Observation Station 8 (1) | 2023.10.24 |
| HeackerRank Basic Select Weather Observation Station 7 (0) | 2023.10.17 |