Prepare > SQL > Basic Select > Weather Observation Station 11

Weather Observation Station 11 | HackerRank

 

문제

---

Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

 

 

 

 

코드

---

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

SELECT DISTINCT(CITY) FROM STATION
WHERE CITY REGEXP "^[^AEIOU]|[^AEIOU]$";

• OR 조건을 | 로 나타내고
• 시작과 끝은 ^와 $로 나타낸것

 

 

 

 

노트

---

SELECT DISTINCT(CITY) FROM STATION
WHERE (CITY NOT LIKE "A%"
    AND CITY NOT LIKE "E%"
    AND CITY NOT LIKE "I%"
    AND CITY NOT LIKE "U%"
    AND CITY NOT LIKE "O%")
    OR
    (CITY NOT LIKE "%A"
     AND CITY NOT LIKE "%E"
     AND CITY NOT LIKE "%I"
     AND CITY NOT LIKE "%O"
     AND CITY NOT LIKE "%U"
    );

 

SELECT DISTINCT(CITY) FROM STATION
WHERE LEFT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U')
    OR RIGHT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U');