数据库 SQL 要怎么求所有系的平均工资啊只会算每个系里的平均值,那所有系的平均值要怎么求啊select avg(salary) as 平均预算 from instructorgroup by dept_name
select dept_name as 系名称,avg(salary) as 平均预算 from instructor group by dept_name;
那就直接avg直接查询不用分组select avg(salary) as 平均预算 from instructor