Schema: CREATE TABLE STUDENT (Advisor VARCHAR)
Question: For each advisor, report the total number of students advised by him or her.
SQL: SELECT Advisor, COUNT(*) FROM STUDENT GROUP BY Advisor