How many courses that do not have prerequisite?
CREATE TABLE prereq (course_id VARCHAR); CREATE TABLE course (course_id VARCHAR)
SELECT COUNT(*) FROM course WHERE NOT course_id IN (SELECT course_id FROM prereq)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE prereq (course_id VARCHAR); CREATE TABLE course (course_id VARCHAR) Question: How many courses that do not have prerequisite? [/INST] SELECT COUNT(*) FROM course WHERE NOT course_id IN (SELECT course_id FROM prereq) </s>