CREATE TABLE student (dept_name VARCHAR)

Find the total number of students in each department.
SELECT COUNT(*), dept_name FROM student GROUP BY dept_name
SELECT COUNT(*), "dept_name" FROM "student" GROUP BY "dept_name"