SELECT Advisor ,  count(*) FROM STUDENT GROUP BY Advisor
For each advisor, report the total number of students advised by him or her.
SELECT Advisor , count ( * ) FROM STUDENT GROUP BY Advisor
select advisor , count ( * ) from student group by advisor
For each advisor , report the total number of students advised by him or her .