What are the names and address for each department?
select dept_name, dept_address from department
Also, how many students are in each department?
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
Which of that information refers to the top 3 departments ordered by 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