SELECT count(DISTINCT advisor) FROM Student
How many different advisors are listed?
SELECT count ( DISTINCT advisor ) FROM Student
select count ( distinct advisor ) from student
How many different advisors are listed ?