Who are the different advisors?
select distinct advisor from student
How many students does each one have?
select advisor, count(*) from student group by advisor