SELECT count(DISTINCT dept_name) FROM department
How many departments does the college has?
SELECT count ( DISTINCT dept_name ) FROM department
select count ( distinct dept_name ) from department
How many departments does the college has ?