统计各专业学生人数

题目描述

学生表

专业表

SELECT
	dept_name,
	ifnull(z_studen.cou, 0) AS '人数'
FROM
	(
		SELECT
			dept_id,
			COUNT(*) AS cou
		FROM
			z_studen
		GROUP BY
			dept_id
	) z_studen
RIGHT JOIN z_department ON z_department.id = z_studen.dept_id