For each advisor, report the total number of students advised by him or her.
select advisor, count(*) from student group by advisor