That's great!  Now can you update this list to include the total number of students for each department?
SELECT T2.dept_name, count ( * )   FROM student AS T1 JOIN department AS T2 ON T1.dept_code   =   T2.dept_code group by T1.dept_code
total number of students for each department refers to COUNT(*) GROUP BY dept_code;