Table schema:
CREATE TABLE Student (Advisor VARCHAR)

Question: Advisor 1121 has how many students?
SQL: SELECT COUNT(*) FROM Student WHERE Advisor = 1121