Who are the students?
select * from student
Who are the distinct advisors?
select distinct advisor from student
How many are there?
select count(distinct advisor) from student