oracle developer 문제풀이4. BETWEEN

문제1. 면적 500~1000 사이의 도시 목록을 조사하라

 

SELECT name AS 도시, area AS 면적
FROM tcity
WHERE area BETWEEN 500 AND 1000;

문제2. 월급이 200만원대인 직원의 목록을 구하라

SELECT name AS 직원이름, salary AS 월급
FROM tstaff
WHERE salary BETWEEN 200 AND 299;