How many students does each advisor have?
select advisor, count(*) from student group by advisor