https://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
Query the list of CITY names ending with vowels (a, e, i, o, 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 6 (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 |