19.查询employees表中各部门的人数.sql

来自「介绍了一些数据库中常用的语句」· SQL 代码 · 共 3 行

select departments.depname as '部门',count(*) as '人数'
from departments inner join employees on departments.depid= employees.department
group by departments.depname