Find the total number of instructors who teach a course in the Spring 2010 semester.
CREATE TABLE teaches (ID VARCHAR, semester VARCHAR, YEAR VARCHAR)
SELECT COUNT(DISTINCT ID) FROM teaches WHERE semester = 'Spring' AND YEAR = 2010
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE teaches (ID VARCHAR, semester VARCHAR, YEAR VARCHAR) Question: Find the total number of instructors who teach a course in the Spring 2010 semester. [/INST] SELECT COUNT(DISTINCT ID) FROM teaches WHERE semester = 'Spring' AND YEAR = 2010 </s>