SQL - 20250627

 

✅ 문제 요약

 

• STATION 테이블에서
• CITY 컬럼이 모음(a, e, i, o, u)으로 끝나는 도시만 선택
• 중복 없이(DISTINCT) 출력

 

---

 

✅ 정답 SQL

SELECT DISTINCT CITY
FROM STATION
WHERE CITY LIKE '%a' 
   OR CITY LIKE '%e' 
   OR CITY LIKE '%i' 
   OR CITY LIKE '%o' 
   OR CITY LIKE '%u';

 

 

 

SELECT DISTINCT CITY
FROM STATION
WHERE LOWER(SUBSTRING(CITY,1,1)) IN ('a','e','i','o','u')
  AND LOWER(SUBSTRING(CITY,-1,1)) IN ('a','e','i','o','u');