oracle developer 문제풀이5. IN

문제1. 총무부나 영업부에 근무하는 직원의 목록을 조사하라

SELECT name AS 직원이름, depart AS 부서명
FROM tstaff
WHERE depart IN ('총무부', '영업부');

문제2. 인사과나 영업부에 근무하는 대리의 목록을 조사하라

SELECT name AS 직원이름, depart AS 부서명, grade AS 직급
FROM tstaff
WHERE depart IN ('인사과', '영업부') AND
grade = '대리';

문제3. 차장급 이상의 여직원 목록을 조사하라

SELECT name AS 직원이름, gender AS 성별, grade AS 직급
FROM tstaff
WHERE gender = '여' AND
grade IN ('차장', '부장', '이사');