How many courses are offered?
CREATE TABLE CLASS (crs_code VARCHAR)
SELECT COUNT(DISTINCT crs_code) FROM CLASS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE CLASS (crs_code VARCHAR) Question: How many courses are offered? [/INST] SELECT COUNT(DISTINCT crs_code) FROM CLASS </s>