select d.dept_name dept_name, count(s.student_id) 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) desc, d.dept_name