子查询课后练习

#子查询的课后练习
#查询和Zlotkey相同部门的员工部门和工资
SELECT last_name,salary
FROM employees
WHERE department_id IN (
													SELECT department_id
													FROM employees
													WHERE last_name = 'Zlotkey'
													);

#选择工资大于所有JOB_ID = ‘SA_MAN’的员工的工资的员工的last_name,job_id,salary
SELECT last_name,