How many students have advisors?
CREATE TABLE advisor (s_id VARCHAR)
SELECT COUNT(DISTINCT s_id) FROM advisor
### Context: CREATE TABLE advisor (s_id VARCHAR) ### Question: How many students have advisors? ### Answer: SELECT COUNT(DISTINCT s_id) FROM advisor