코딩코딩코딩

Answer SELECT name FROM students WHERE marks > 75 ORDER BY SUBSTRING(name, -3), id;

Answer SELECT name FROM employee WHERE salary >= 2000 AND months < 10 ORDER BY employee_id;

Answer SELECT name FROM employee ORDER BY name;

SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP "^[^aeiou]" AND CITY REGEXP "[^aeiou]$";

OR 연산자 구조를 잘 생각해야 함. A or B 인 경우 A나 B가 둘 중 하나라도 True 이거나 모두 True 인 경우에 True를 반환 따라서 1. (not A) or (not B) 2. not (A or B) = (not A) and (not B) [1] SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP "^[^aeiou]|[^aeiou]$"; [2] SELECT DISTINCT(CITY) FROM STATION WHERE CITY NOT REGEXP "^[aeiou]" OR CITY NOT REGEXP "[aeiou]$"; [3] -- Wrong Answer SELECT DISTINCT(CITY) FROM STATION WHERE CITY NOT R..

-- NOT LIKE 연산자 사용 SELECT DISTINCT(CITY) FROM STATION WHERE CITY NOT LIKE "a%" AND CITY NOT LIKE "e%" AND CITY NOT LIKE "i%" AND CITY NOT LIKE "o%" AND CITY NOT LIKE "u%"; -- REGEXP 사용 SELECT DISTINCT(CITY) FROM STATION WHERE CITY NOT REGEXP "^[aeiou]";