SELECT count(DISTINCT department_id) FROM Degree_Programs
How many departments offer any degree?
SELECT count ( DISTINCT department_id ) FROM Degree_Programs
select count ( distinct department_id ) from degree_programs
How many departments offer any degree ?