How many schools do not have a school bus?
select count(*) from school where school_id not in (select school_id from school_bus)
What are the names of these schools?
select school from school where school_id not in (select school_id from school_bus)
Please also show the school types.
select school, type from school where school_id not in (select school_id from school_bus)