oracle developer 문제풀이2

문제1. 직원 목록에서 월급이 300미만이면서 성취도는 60이상인 직원이 누구인지 조사하라

 

SELECT name AS 직원이름, salary AS 월급, score AS 성취도
FROM tstaff
WHERE salary < 300 AND score >= 60;

문제2. 영업부의 여직원 이름을 조사하라

SELECT name AS 이름, gender AS 성별 FROM tstaff
WHERE gender = '여' AND depart = '영업부';