text: CREATE TABLE university (school_id VARCHAR); CREATE TABLE basketball_match (school_id VARCHAR) -- How many schools do not participate in the basketball match? SELECT COUNT(*) FROM university WHERE NOT school_id IN (SELECT school_id FROM basketball_match) CREATE TABLE university (school VARCHAR, founded VARCHAR, affiliation VARCHAR) -- Find the schools that were either founded after 1850 or public. SELECT school FROM university WHERE founded > 1850 OR affiliation = 'Public' CREATE TABLE university (affiliation VARCHAR) -- Find how many different affiliation types there are. SELECT COUNT(DISTINCT affiliation) FROM university CREATE TABLE university (LOCATION VARCHAR) -- Find how many school locations have the word 'NY'. SELECT COUNT(*) FROM university WHERE LOCATION LIKE "%NY%" CREATE TABLE university (school_id VARCHAR); CREATE TABLE basketball_match (team_name VARCHAR, school_id VARCHAR); CREATE TABLE university (enrollment INTEGER) -- Find the team names of the universities whose enrollments are smaller than the average enrollment size. SELECT t2.team_name FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id = t2.school_id WHERE enrollment < (SELECT AVG(enrollment) FROM university) CREATE TABLE university (affiliation VARCHAR, enrollment INTEGER) -- Find the number of universities that have over a 20000 enrollment size for each affiliation type. SELECT COUNT(*), affiliation FROM university WHERE enrollment > 20000 GROUP BY affiliation