Hello  Can you provide me with a list of all of the different department names?
select dept_name from department
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
Can you update this list to show the Department Name, Department Address, and number of students for the 3 departments with the highest number of students?
select t2.dept_name, t2.dept_address, count ( * ) from student as t1 join department as t2 on t1.dept_code = t2.dept_code group by t1.dept_code order by count ( * ) desc limit 3