Database: college_2
Question: Count the number of departments which offer courses.
SQL:
SELECT count(DISTINCT dept_name) FROM course