How many students have advisors?
CREATE TABLE advisor (s_id VARCHAR)
SELECT COUNT(DISTINCT s_id) FROM advisor
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE advisor (s_id VARCHAR) Question: How many students have advisors? [/INST] SELECT COUNT(DISTINCT s_id) FROM advisor </s>