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