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 ?