[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');
'데이터베이스 > SQL' 카테고리의 다른 글
[HackerRank] Japan Population (0) | 2021.01.21 |
---|---|
[HackerRank] Employee Names (0) | 2021.01.21 |
[HackerRank] Weather Observation Station 5 (0) | 2021.01.20 |
[HackerRank] Weather Observation Station 4 (0) | 2021.01.20 |
[HackerRank] Weather Observation Station 3 (0) | 2021.01.20 |