How many students and instructors are in 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
[{'count(DISTINCT T2.id)': 99, 'count(DISTINCT T3.id)': 4, 'dept_name': 'Accounting'}, {'count(DISTINCT T2.id)': 106, 'count(DISTINCT T3.id)': 1, 'dept_name': 'Astronomy'}, {'count(DISTINCT T2.id)': 92, 'count(DISTINCT T3.id)': 5, 'dept_name': 'Athletics'}, {'count(DISTINCT T2.id)': 100, 'count(DISTINCT T3.id)': 2, 'dept_name': 'Biology'}, {'count(DISTINCT T2.id)': 108, 'count(DISTINCT T3.id)': 2, 'dept_name': 'Comp. Sci.'}, {'count(DISTINCT T2.id)': 86, 'count(DISTINCT T3.id)': 4, 'dept_name': 'Cybernetics'}, {'count(DISTINCT T2.id)': 98, 'count(DISTINCT T3.id)': 4, 'dept_name': 'Elec. Eng.'}, {'count(DISTINCT T2.id)': 95, 'count(DISTINCT T3.id)': 4, 'dept_name': 'English'}, {'count(DISTINCT T2.id)': 97, 'count(DISTINCT T3.id)': 1, 'dept_name': 'Finance'}, {'count(DISTINCT T2.id)': 92, 'count(DISTINCT T3.id)': 1, 'dept_name': 'Geology'}, {'count(DISTINCT T2.id)': 119, 'count(DISTINCT T3.id)': 3, 'dept_name': 'Languages'}, {'count(DISTINCT T2.id)': 85, 'count(DISTINCT T3.id)': 4, 'dept_name': 'Marketing'}, {'count(DISTINCT T2.id)': 105, 'count(DISTINCT T3.id)': 2, 'dept_name': 'Mech. Eng.'}, {'count(DISTINCT T2.id)': 96, 'count(DISTINCT T3.id)': 2, 'dept_name': 'Physics'}, {'count(DISTINCT T2.id)': 109, 'count(DISTINCT T3.id)': 3, 'dept_name': 'Pol. Sci.'}, {'count(DISTINCT T2.id)': 100, 'count(DISTINCT T3.id)': 2, 'dept_name': 'Psychology'}, {'count(DISTINCT T2.id)': 85, 'count(DISTINCT T3.id)': 6, 'dept_name': 'Statistics'}]