若想统计各个工种的人数与平均工资,正确的语句是()
A. select job,mgr,count(*),avg(sal) from emp group by job ;
B. select job,ename,count(*),avg(sal) from emp group by job ;
C. select job,count(*),avg(sal) from emp group by job ;
D. select job,count(*) from emp group by job ;
查看答案
该试题由用户803****39提供
查看答案人数:38519
如遇到问题请联系客服
正确答案
该试题由用户803****39提供
查看答案人数:38520
如遇到问题请联系客服