列出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;