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