SQL 查询：统计每个专业学生人数并排序

SELECT department.name, COUNT(student.id) as student_count FROM department LEFT JOIN student ON department.id = student.department_id GROUP BY department.id ORDER BY student_count DESC, department.name ASC