列出EMP表中 从事每个工种(JOB)的员工人数()

列出EMP表中，从事每个工种（JOB）的员工人数()

A.select job from emp;

B.select job,count(*) from emp;

C.select distinct job,count(*) from emp;

D.select job,count(*) from emp group by job;

E.select job,sum(empno) from emp group by job;