
CREATE TABLE basketball_match (
	"Team_ID" INTEGER, 
	"School_ID" INTEGER, 
	"Team_Name" TEXT, 
	"ACC_Regular_Season" TEXT, 
	"ACC_Percent" TEXT, 
	"ACC_Home" TEXT, 
	"ACC_Road" TEXT, 
	"All_Games" TEXT, 
	"All_Games_Percent" INTEGER, 
	"All_Home" TEXT, 
	"All_Road" TEXT, 
	"All_Neutral" TEXT, 
	PRIMARY KEY ("Team_ID"), 
	FOREIGN KEY("School_ID") REFERENCES university ("School_ID")
)


CREATE TABLE university (
	"School_ID" INTEGER, 
	"School" TEXT, 
	"Location" TEXT, 
	"Founded" REAL, 
	"Affiliation" TEXT, 
	"Enrollment" REAL, 
	"Nickname" TEXT, 
	"Primary_conference" TEXT, 
	PRIMARY KEY ("School_ID")
)

CREATE TABLE basketball_match (
	"Team_ID" INTEGER, 
	"School_ID" INTEGER, 
	"Team_Name" TEXT, 
	"ACC_Regular_Season" TEXT, 
	"ACC_Percent" TEXT, 
	"ACC_Home" TEXT, 
	"ACC_Road" TEXT, 
	"All_Games" TEXT, 
	"All_Games_Percent" INTEGER, 
	"All_Home" TEXT, 
	"All_Road" TEXT, 
	"All_Neutral" TEXT, 
	PRIMARY KEY ("Team_ID"), 
	FOREIGN KEY("School_ID") REFERENCES university ("School_ID")
)

/*
2 rows from basketball_match table:
Team_ID	School_ID	Team_Name	ACC_Regular_Season	ACC_Percent	ACC_Home	ACC_Road	All_Games	All_Games_Percent	All_Home	All_Road	All_Neutral
1	1	North Carolina	14–2	.875	6–2	8–0	35–2	0.946	14–2	13–0	9–1
2	2	Duke	13–3	.813	7–1	6–2	28–6	0.824	15–1	8–2	5–3
*/


CREATE TABLE university (
	"School_ID" INTEGER, 
	"School" TEXT, 
	"Location" TEXT, 
	"Founded" REAL, 
	"Affiliation" TEXT, 
	"Enrollment" REAL, 
	"Nickname" TEXT, 
	"Primary_conference" TEXT, 
	PRIMARY KEY ("School_ID")
)

/*
2 rows from university table:
School_ID	School	Location	Founded	Affiliation	Enrollment	Nickname	Primary_conference
1	University of Delaware	Newark, DE	1743.0	Public	19067.0	Fightin' Blue Hens	Colonial Athletic Association ( D-I )
2	Lebanon Valley College	Annville, PA	1866.0	Private/Methodist	2100.0	Flying Dutchmen	MAC Commonwealth Conference ( D-III )
*/
How many schools do not participate in the basketball match?
SELECT count(*) FROM university WHERE school_id NOT IN (SELECT school_id FROM basketball_match)
[{'count(*)': 1}]