www.hackerrank.com/challenges/weather-observation-station-11/problem
Weather Observation Station 11 | HackerRank
Query a list of CITY names not starting or ending with vowels.
www.hackerrank.com
Answer
select distinct city
from station
where city not regexp '^[aeiou]' or city not regexp '[aeiou]$'
www.hackerrank.com/challenges/weather-observation-station-12/problem
Weather Observation Station 12 | HackerRank
Query an alphabetically ordered list of CITY names not starting and ending with vowels.
www.hackerrank.com
select distinct city
from station
where city not regexp '^[aeiou]' and city not regexp '[aeiou]$'728x90
반응형
'SQL & DB > HackerRank SQL Problem' 카테고리의 다른 글
| [HackerRank SQL] Employee Names, Employee Salaries (0) | 2021.02.27 |
|---|---|
| [HackerRank SQL] Higher Than 75 Marks (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 9, 10(MySQL) (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 7, 8(MySQL) (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 5, 6(MySQL) (0) | 2021.02.27 |