Show the school name and type for schools without a school bus.
CREATE TABLE school_bus (school VARCHAR, TYPE VARCHAR, school_id VARCHAR); CREATE TABLE school (school VARCHAR, TYPE VARCHAR, school_id VARCHAR)
SELECT school, TYPE FROM school WHERE NOT school_id IN (SELECT school_id FROM school_bus)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE school_bus (school VARCHAR, TYPE VARCHAR, school_id VARCHAR); CREATE TABLE school (school VARCHAR, TYPE VARCHAR, school_id VARCHAR) Question: Show the school name and type for schools without a school bus. [/INST] SELECT school, TYPE FROM school WHERE NOT school_id IN (SELECT school_id FROM school_bus) </s>