[HackerRank] Weather Observation Station 6

2021. 1. 21. 21:15데이터베이스/SQL

728x90
반응형

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:


SELECT CITY FROM STATION 
WHERE regexp_like (CITY, '^a|^e|^i|^o|^u');