Schema: CREATE TABLE Student (advisor VARCHAR)
Question: Show all advisors and corresponding number of students.
SQL: SELECT advisor, COUNT(*) FROM Student GROUP BY advisor