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