数据库-分组函数
找出所有部门的avg工资
select departsment_id,avg(salary)
from employees
group by departsment_id
找出avg工资大于6000的部门
select departsment_id,avg(salary)
from employees
having avg(salary) > 6000
group by employed_id
order by departsment_id asc
数据库-分组函数
找出所有部门的avg工资
select departsment_id,avg(salary)
from employees
group by departsment_id
找出avg工资大于6000的部门
select departsment_id,avg(salary)
from employees
having avg(salary) > 6000
group by employed_id
order by departsment_id asc