Find the number of students for each department.
SELECT count(*) ,  dept_code FROM student GROUP BY dept_code
SELECT count(*) ,  dept_code FROM student GROUP BY dept_code
[{'count(*)': 3, 'DEPT_CODE': 'ACCT'}, {'count(*)': 1, 'DEPT_CODE': 'BIOL'}, {'count(*)': 2, 'DEPT_CODE': 'CIS'}, {'count(*)': 1, 'DEPT_CODE': 'EDU'}, {'count(*)': 1, 'DEPT_CODE': 'ENGL'}]