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