www.hackerrank.com/challenges/weather-observation-station-7/problem
Weather Observation Station 7 | HackerRank
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION.
www.hackerrank.com
Answer
select distinct city
from station
where city regexp '[aeiou]$'정규표현식에서 ~로 끝나는 것을 나타내는 것은 '$'이다.
www.hackerrank.com/challenges/weather-observation-station-8/problem
Weather Observation Station 8 | HackerRank
Query CITY names that start AND end with vowels.
www.hackerrank.com
select distinct city
from station
where city regexp '^[aeiou]' and city regexp '[aeiou]$'
728x90
반응형
'SQL & DB > HackerRank SQL Problem' 카테고리의 다른 글
| [HackerRank SQL] Weather Observation Station 11, 12(MySQL) (0) | 2021.02.27 |
|---|---|
| [HackerRank SQL] Weather Observation Station 9, 10(MySQL) (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 5, 6(MySQL) (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 3, 4(MySQL) (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 1, 2 (MySQL) (0) | 2021.02.27 |