SELECT school, TYPE FROM school WHERE NOT school_id IN (SELECT school_id FROM school_bus)
Tunjukkan nama dan jenis sekolah untuk sekolah tanpa bus sekolah.
CREATE TABLE school_bus (school VARCHAR, TYPE VARCHAR, school_id VARCHAR); CREATE TABLE school (school VARCHAR, TYPE VARCHAR, school_id VARCHAR)