Table schema:
CREATE TABLE DEPARTMENT (Division VARCHAR)

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