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

介绍了一些数据库中常用的语句

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