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