SELECT count(*) FROM DEPARTMENT WHERE Division  =  "AS"
How many departments are in the division AS?
SELECT count ( * ) FROM DEPARTMENT WHERE Division = `` AS ''
select count ( * ) from department where division = value
How many departments are in the division AS ?