How many schools do not participate in the basketball match?
create table university (school_id varchar, PRIMARY KEY (school_id)); create table basketball_match (school_id varchar, PRIMARY KEY (school_id))
select count(*) from university where not school_id in (select school_id from basketball_match)