What are the different department names?
select distinct dept_name from department
How many does it offer?
select count(distinct dept_name) from department