[打卡]练习

2024-05-28 10:15:01

169

1 查询和zlotkey相同部门的员工姓名和工资
SELECT last_name,salary
FROM employees
WHERE department_id=(
SELECT department_id
FROM employees
WHERE last_name='Zlotkey'
);

2查询工资比公司平均工资高的员工的员工号，姓名和工资

SELECT employee_id,last_name,salary
FROM employees
WHERE salary>(
SELECT AVG(salary)
FROM employees

);