How many sections does each course has?
CREATE TABLE CLASS (crs_code VARCHAR)
SELECT COUNT(*), crs_code FROM CLASS GROUP BY crs_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE CLASS (crs_code VARCHAR) Question: How many sections does each course has? [/INST] SELECT COUNT(*), crs_code FROM CLASS GROUP BY crs_code </s>