How many students are in each department?
SELECT count(*) ,  dept_name FROM student GROUP BY dept_name
SELECT count(*) ,  dept_name FROM student GROUP BY dept_name
[{'count(*)': 99, 'dept_name': 'Accounting'}, {'count(*)': 106, 'dept_name': 'Astronomy'}, {'count(*)': 92, 'dept_name': 'Athletics'}, {'count(*)': 100, 'dept_name': 'Biology'}, {'count(*)': 120, 'dept_name': 'Civil Eng.'}, {'count(*)': 108, 'dept_name': 'Comp. Sci.'}, {'count(*)': 86, 'dept_name': 'Cybernetics'}, {'count(*)': 98, 'dept_name': 'Elec. Eng.'}, {'count(*)': 95, 'dept_name': 'English'}, {'count(*)': 97, 'dept_name': 'Finance'}, {'count(*)': 92, 'dept_name': 'Geology'}, {'count(*)': 117, 'dept_name': 'History'}, {'count(*)': 119, 'dept_name': 'Languages'}, {'count(*)': 85, 'dept_name': 'Marketing'}, {'count(*)': 91, 'dept_name': 'Math'}, {'count(*)': 105, 'dept_name': 'Mech. Eng.'}, {'count(*)': 96, 'dept_name': 'Physics'}, {'count(*)': 109, 'dept_name': 'Pol. Sci.'}, {'count(*)': 100, 'dept_name': 'Psychology'}, {'count(*)': 85, 'dept_name': 'Statistics'}]