SELECT advisor ,  count(*) FROM Student GROUP BY advisor
Show all advisors and corresponding number of students.
SELECT advisor , count ( * ) FROM Student GROUP BY advisor
select advisor , count ( * ) from student group by advisor
Show all advisors and corresponding number of students .