关系模式department(code,name)、employee(code,name,sex,dept,phone),查询每个部门的员工数量,查询结果包括code,name,emps,正确的语句是()
A.
select code, name,emps from department de left join (select dept,count(*) emps from employee group by dept) vem on de.code=vem.dept;
B.
select code, name ,count(*) emps from department de,employee group by dept on de.code=em.dept;
C.
select code, name, count(*) emps from department de,employee group by dept where de.code=em.dept;
D.
select code, name, count(*) emps from department de,employee on de.code=em.dept group by dept;