Table schema:
CREATE TABLE course (dept_name VARCHAR)

Question: How many departments offer courses?
SQL: SELECT COUNT(DISTINCT dept_name) FROM course