对工资表(员工号,姓名,部门号,月薪)进行查询,分部门统计人数和平均公司,查询语句应( )
A、Select 部门号,Count(*),AVG(月薪) from 工资表 group by 月薪
B、Select 部门号,Count(*),AVG(月薪) from 工资表 group by 部门号
C、Select 部门号,Count(月薪),AVG(*) from 工资表 group by 部门号
D、Select 部门号,Count(月薪),AVG(月薪) from 工资表 group by 月薪
A、Select 部门号,Count(*),AVG(月薪) from 工资表 group by 月薪
B、Select 部门号,Count(*),AVG(月薪) from 工资表 group by 部门号
C、Select 部门号,Count(月薪),AVG(*) from 工资表 group by 部门号
D、Select 部门号,Count(月薪),AVG(月薪) from 工资表 group by 月薪