为自己加油

以下查询语句合法的是( )

A.select * from scott.emp;
B.select count(empno) from scott.emp;
C.select sum(sal) from scott.emp group by deptno;
D.Aselect empno ,sum(sal) from scott.emp group by deptno;