SELECT count(DISTINCT T2.id) ,  count(DISTINCT T3.id) ,  T3.dept_name FROM department AS T1 JOIN student AS T2 ON T1.dept_name  =  T2.dept_name JOIN instructor AS T3 ON T1.dept_name  =  T3.dept_name GROUP BY T3.dept_name
Find the total number of students and total number of instructors for each department.
SELECT count ( DISTINCT T2.id ) , count ( DISTINCT T3.id ) , T3.dept_name FROM department AS T1 JOIN student AS T2 ON T1.dept_name = T2.dept_name JOIN instructor AS T3 ON T1.dept_name = T3.dept_name GROUP BY T3.dept_name
select count ( distinct t2 . id ) , count ( distinct t3 . id ) , t3 . dept_name from department as t1 join student as t2 on t1 . dept_name = t2 . dept_name join instructor as t3 on t1 . dept_name = t3 . dept_name group by t3 . dept_name
Find the total number of students and total number of instructors for each department .