CREATE TABLE course (dept_name VARCHAR, credits INT)

Find the total credits of courses provided by different department.
SELECT SUM(credits), dept_name FROM course GROUP BY dept_name
SELECT SUM("credits"), "dept_name" FROM "course" GROUP BY "dept_name"