SELECT school ,  TYPE FROM school WHERE school_id NOT IN (SELECT school_id FROM school_bus)
Show the school name and type for schools without a school bus.
SELECT school , TYPE FROM school WHERE school_id NOT IN ( SELECT school_id FROM school_bus )
select school , type from school where school_id not in ( select school_id from school_bus )
Show the school name and type for schools without a school bus .