SELECT count(DISTINCT dept_name) FROM course
Count the number of departments which offer courses.
SELECT count ( DISTINCT dept_name ) FROM course
select count ( distinct dept_name ) from course
Count the number of departments which offer courses .