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)
### Context: 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. ### Answer: SELECT school, TYPE FROM school WHERE NOT school_id IN (SELECT school_id FROM school_bus)