https://www.hackerrank.com/challenges/weather-observation-station-6/problem
Weather Observation Station 6 | HackerRank
Query a list of CITY names beginning with vowels (a, e, i, o, u).
www.hackerrank.com
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:
a,e,i,o,u 로 시작하는 CITY를 중복없이 찾는 문제
OR로 조건을 추가하거나 정규표현식으로 해결가능
반응형
'지식저장소 > SQL' 카테고리의 다른 글
| [SQL/MYSQL] HackerRank - Weather Observation Station 9 (0) | 2022.06.10 |
|---|---|
| [SQL/MYSQL] HackerRank - Weather Observation Station 8 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 7 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 5 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 4 (0) | 2022.06.10 |