SQL 查询：统计各部门员工数量

SELECT dept.deptno, dept.dname, dept.loc, COUNT(emp.empno) as total FROM dept LEFT JOIN emp ON dept.deptno = emp.deptno GROUP BY dept.deptno, dept.dname, dept.loc;