Schema: CREATE TABLE DEPARTMENT (Division VARCHAR)
Question: What is the number of departments in Division "AS"?
SQL: SELECT COUNT(*) FROM DEPARTMENT WHERE Division = "AS"