January 1, 0001

select d.dept_name, count(s.student_id) as student_number from department d left join student s on d.dept_id = s.dept_id group by d.dept_name order by count(s.student_id), d.dept_name