[hackerrank, SQL]Weather Observation Station 7

문제 풀러 가기

 

 

문제 풀이에 대해 생각한 부분

1. 중복을 포함할 수 없음 (DISTINCT)

2. 정규표현식

3. LIKE

 

SELECT 
	DISTINCT city
FROM 
	station
WHERE 
	city REGEXP '[aeiou]$'
    ;

 

 

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')
    ;