CREATE TABLE student (dept_name VARCHAR(255))
Find the total number of students in each department.
    
SQL: SELECT COUNT(*), dept_name FROM student GROUP BY dept_name