How many courses are offered by the Computer Info. Systems department?
CREATE TABLE course (dept_code VARCHAR); CREATE TABLE department (dept_code VARCHAR)
SELECT COUNT(*) FROM department AS T1 JOIN course AS T2 ON T1.dept_code = T2.dept_code WHERE dept_name = "Computer Info. Systems"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE course (dept_code VARCHAR); CREATE TABLE department (dept_code VARCHAR) Question: How many courses are offered by the Computer Info. Systems department? [/INST] SELECT COUNT(*) FROM department AS T1 JOIN course AS T2 ON T1.dept_code = T2.dept_code WHERE dept_name = "Computer Info. Systems" </s>