How many schools do not participate in the basketball match?
CREATE TABLE university (school_id VARCHAR); CREATE TABLE basketball_match (school_id VARCHAR)
[SQL] SELECT COUNT(*) FROM university WHERE NOT school_id IN (SELECT school_id FROM basketball_match) [/SQL]