https://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
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.
Input Format
The STATION table is described as follows:
STATION 테이블에서 a,e,i,o,u로 시작하고 a,e,i,o,u로 끝나는 CITY를 찾는 문제
반응형
'지식저장소 > SQL' 카테고리의 다른 글
| [SQL/MYSQL] HackerRank - Weather Observation Station 10 (0) | 2022.06.10 |
|---|---|
| [SQL/MYSQL] HackerRank - Weather Observation Station 9 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 7 (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 |