SCHEMA:
CREATE TABLE department (dept_name VARCHAR)
USER:
How many departments does the college has?

QUERY:
SELECT COUNT(DISTINCT dept_name) FROM department