How many professors are teaching class with code ACCT-211?
CREATE TABLE CLASS (PROF_NUM VARCHAR, CRS_CODE VARCHAR)
SELECT COUNT(DISTINCT PROF_NUM) FROM CLASS WHERE CRS_CODE = "ACCT-211"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE CLASS (PROF_NUM VARCHAR, CRS_CODE VARCHAR) Question: How many professors are teaching class with code ACCT-211? [/INST] SELECT COUNT(DISTINCT PROF_NUM) FROM CLASS WHERE CRS_CODE = "ACCT-211" </s>