Table schema:
CREATE TABLE advisor (s_id VARCHAR)

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