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