SELECT count(DISTINCT dept_name) FROM course
How many departments offer courses?
SELECT count ( DISTINCT dept_name ) FROM course
select count ( distinct dept_name ) from course
How many departments offer courses ?