Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.
[My Answer]
|
1
2
3
4
|
SELECT DISTINCT CITY
FROM STATION
WHERE CITY NOT REGEXP '^[aeiou]'
and CITY NOT REGEXP '[aeiou]$'
|
cs |
'Code Problems > SQL_ HackerRank' 카테고리의 다른 글
| [HackerRank] Employee Names (0) | 2021.07.30 |
|---|---|
| [HackerRank] Higher Than 75 Marks (0) | 2021.07.17 |
| [HackerRank] Weather Observation Station 11 (0) | 2021.07.06 |
| [HackerRank] Weather Observation Station 10 (0) | 2021.07.01 |
| [HackerRank] Weather Observation Station 9 (0) | 2021.05.01 |