CREATE TABLE university (school_id NUMBER, school CLOB, location CLOB, founded NUMBER, affiliation CLOB, enrollment NUMBER, nickname CLOB, primary_conference CLOB)
CREATE TABLE basketball_match (team_id NUMBER, school_id NUMBER, team_name CLOB, acc_regular_season CLOB, acc_percent CLOB, acc_home CLOB, acc_road CLOB, all_games CLOB, all_games_percent NUMBER, all_home CLOB, all_road CLOB, all_neutral CLOB)

How many schools are in the basketball match?
SELECT COUNT(DISTINCT school_id) FROM basketball_match
SELECT COUNT(DISTINCT "school_id") FROM "basketball_match"