Database: college_2
Question: Count the number of students who have advisors.
SQL:
SELECT count(DISTINCT s_id) FROM advisor