Table 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