【多选题】
A select * from employees where salary>(select min(salary) from employees group by department.id);
B select * from employees where salary=(select avg(salary) from employees group by department_id)
C select department_id from employees where salary>all (select avg(salary) from employees group by department_id)
D select last_name from employees where salary>any(select max(salary) from employees group by department_id)
查看更多
