SELECT count(DISTINCT s_id) FROM advisor
Count the number of students who have advisors.
SELECT count ( DISTINCT s_id ) FROM advisor
select count ( distinct s_id ) from advisor
Count the number of students who have advisors .