
CREATE TABLE player (
	"Player_ID" INTEGER, 
	"Player" TEXT, 
	"Team" TEXT, 
	"Age" INTEGER, 
	"Position" TEXT, 
	"School_ID" INTEGER, 
	PRIMARY KEY ("Player_ID"), 
	FOREIGN KEY("School_ID") REFERENCES school ("School_ID")
)


CREATE TABLE school (
	"School_ID" INTEGER, 
	"School" TEXT, 
	"Location" TEXT, 
	"Enrollment" REAL, 
	"Founded" REAL, 
	"Denomination" TEXT, 
	"Boys_or_Girls" TEXT, 
	"Day_or_Boarding" TEXT, 
	"Year_Entered_Competition" REAL, 
	"School_Colors" TEXT, 
	PRIMARY KEY ("School_ID")
)


CREATE TABLE school_details (
	"School_ID" INTEGER, 
	"Nickname" TEXT, 
	"Colors" TEXT, 
	"League" TEXT, 
	"Class" TEXT, 
	"Division" TEXT, 
	PRIMARY KEY ("School_ID"), 
	FOREIGN KEY("School_ID") REFERENCES school ("School_ID")
)


CREATE TABLE school_performance (
	"School_Id" INTEGER, 
	"School_Year" TEXT, 
	"Class_A" TEXT, 
	"Class_AA" TEXT, 
	PRIMARY KEY ("School_Id", "School_Year"), 
	FOREIGN KEY("School_Id") REFERENCES school ("School_ID")
)

CREATE TABLE player (
	"Player_ID" INTEGER, 
	"Player" TEXT, 
	"Team" TEXT, 
	"Age" INTEGER, 
	"Position" TEXT, 
	"School_ID" INTEGER, 
	PRIMARY KEY ("Player_ID"), 
	FOREIGN KEY("School_ID") REFERENCES school ("School_ID")
)

/*
2 rows from player table:
Player_ID	Player	Team	Age	Position	School_ID
1	Timothy Beckham	Tampa Bay Devil Rays	15	Shortstop	1
2	Pedro Álvarez	Pittsburgh Pirates	14	Third baseman	2
*/


CREATE TABLE school (
	"School_ID" INTEGER, 
	"School" TEXT, 
	"Location" TEXT, 
	"Enrollment" REAL, 
	"Founded" REAL, 
	"Denomination" TEXT, 
	"Boys_or_Girls" TEXT, 
	"Day_or_Boarding" TEXT, 
	"Year_Entered_Competition" REAL, 
	"School_Colors" TEXT, 
	PRIMARY KEY ("School_ID")
)

/*
2 rows from school table:
School_ID	School	Location	Enrollment	Founded	Denomination	Boys_or_Girls	Day_or_Boarding	Year_Entered_Competition	School_Colors
1	St Aloysius' College	Milsons Point	1200.0	1879.0	Catholic	Boys	Day	1929.0	Royal Blue and Gold
2	Barker College	Hornsby	2300.0	1890.0	Anglican	Boys only to Yr 9 Co-ed Year 10 to 12	Day & Boarding	1929.0	Red & Blue
*/


CREATE TABLE school_details (
	"School_ID" INTEGER, 
	"Nickname" TEXT, 
	"Colors" TEXT, 
	"League" TEXT, 
	"Class" TEXT, 
	"Division" TEXT, 
	PRIMARY KEY ("School_ID"), 
	FOREIGN KEY("School_ID") REFERENCES school ("School_ID")
)

/*
2 rows from school_details table:
School_ID	Nickname	Colors	League	Class	Division
1	Tigers	Blue and Yellow	DSHA	Flight A	Division 1
2	Auks	Dark Green and White	DSHA	Flight B	Division 3
*/


CREATE TABLE school_performance (
	"School_Id" INTEGER, 
	"School_Year" TEXT, 
	"Class_A" TEXT, 
	"Class_AA" TEXT, 
	PRIMARY KEY ("School_Id", "School_Year"), 
	FOREIGN KEY("School_Id") REFERENCES school ("School_ID")
)

/*
2 rows from school_performance table:
School_Id	School_Year	Class_A	Class_AA
1	1987-88	Yantis	Blanco
1	1988-89	Happy	Blanco
*/
Show the denomination of the school that has the most players.
SELECT T2.Denomination FROM player AS T1 JOIN school AS T2 ON T1.School_ID  =  T2.School_ID GROUP BY T1.School_ID ORDER BY COUNT(*) DESC LIMIT 1
[{'Denomination': 'Catholic'}]