What are the school names of the schools without school buses?
select school from school where school_id not in ( select school_id from school_bus )
Can you please get me the types of those schools?
select type from school where school_id not in ( select school_id from school_bus )
what are schools in Hawaii have school buses?
select school from school where location like "%hawaii%" and school_id in ( select school_id from school_bus )
What about in Indonesia?
select school from school where location like "%Indonesia" and school_id in ( select school_id from school_bus )
How many private schools are in Hawaii?
select count ( * ) from school where location like "%Hawaii" and type = "Private"