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