How many schools do not participate in the basketball match?
CREATE TABLE university (school_id VARCHAR); CREATE TABLE basketball_match (school_id VARCHAR)
SELECT COUNT(*) FROM university WHERE NOT school_id IN (SELECT school_id FROM basketball_match)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE university (school_id VARCHAR); CREATE TABLE basketball_match (school_id VARCHAR) Question: How many schools do not participate in the basketball match? [/INST] SELECT COUNT(*) FROM university WHERE NOT school_id IN (SELECT school_id FROM basketball_match) </s>