[MySQL] Hacker Rank 문제 연습 4

Weather Observation Station 10 (Basic Select)

• 

제출한 쿼리 :

SELECT DISTINCT CITY
FROM STATION
WHERE RIGHT(CITY, 1) NOT IN ('a', 'e', 'i', 'o', 'u');

---

Weather Observation Station 11 (Basic Select)

• 

제출한 쿼리 :

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');

---

Weather Observation Station 12 (Basic Select)

• 

제출한 쿼리 :

SELECT DISTINCT CITY
FROM STATION 
WHERE LEFT(CITY, 1) NOT IN ('a', 'e', 'i', 'o', 'u')
    AND RIGHT(CITY, 1)  NOT IN ('a', 'e', 'i', 'o', 'u');

---

Higher Than 75 Marks (Basic Select)

• 

제출한 쿼리 :

SELECT NAME
FROM STUDENTS
WHERE MARKS  > 75
ORDER BY RIGHT(NAME, 3) ASC, ID ASC;

---

Employee Names (Basic Select)

• 

제출한 쿼리 :

SELECT NAME
FROM EMPLOYEE
ORDER BY NAME ASC;

---