SELECT Advisor ,  count(*) FROM STUDENT GROUP BY Advisor
How many students does each advisor have?
SELECT Advisor , count ( * ) FROM STUDENT GROUP BY Advisor
select advisor , count ( * ) from student group by advisor
How many students does each advisor have ?