Prepare > SQL > Basic Select > Weather Observation Station 12

Weather Observation Station 12 | HackerRank

 

문제

---

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.

 

 

 

 

코드

---

SELECT DISTINCT(CITY) FROM STATION
WHERE LEFT(CITY, 1) REGEXP "[^AEIOU]"
    AND RIGHT(CITY, 1) REGEXP "[^AEIOU]";

SELECT DISTINCT(CITY) FROM STATION
WHERE CITY REGEXP '^[^AEIOU].*[^AEIOU]$';

 

 

 

 

참조

---

Prepare > SQL > Basic Select > Weather Observation Station 11