Table schema:
CREATE TABLE Student (advisor VARCHAR)

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