Database: college_2
Question: How many students have advisors?
SQL:
SELECT count(DISTINCT s_id) FROM advisor