Table schema:
CREATE TABLE department (dept_name VARCHAR)

Question: How many departments does the college has?
SQL: SELECT COUNT(DISTINCT dept_name) FROM department