
CREATE TABLE "Institution" (
	"Institution_id" TEXT, 
	"Institution" TEXT, 
	"Location" TEXT, 
	"Founded" REAL, 
	"Type" TEXT, 
	"Enrollment" INTEGER, 
	"Team" TEXT, 
	"Primary_Conference" TEXT, 
	building_id TEXT, 
	PRIMARY KEY ("Institution_id"), 
	FOREIGN KEY(building_id) REFERENCES building (building_id)
)


CREATE TABLE building (
	building_id TEXT, 
	"Name" TEXT, 
	"Street_address" TEXT, 
	"Years_as_tallest" TEXT, 
	"Height_feet" INTEGER, 
	"Floors" INTEGER, 
	PRIMARY KEY (building_id)
)


CREATE TABLE protein (
	common_name TEXT, 
	protein_name TEXT, 
	divergence_from_human_lineage REAL, 
	accession_number TEXT, 
	sequence_length REAL, 
	sequence_identity_to_human_protein TEXT, 
	"Institution_id" TEXT, 
	PRIMARY KEY (common_name), 
	FOREIGN KEY("Institution_id") REFERENCES "Institution" ("Institution_id")
)

CREATE TABLE "Institution" (
	"Institution_id" TEXT, 
	"Institution" TEXT, 
	"Location" TEXT, 
	"Founded" REAL, 
	"Type" TEXT, 
	"Enrollment" INTEGER, 
	"Team" TEXT, 
	"Primary_Conference" TEXT, 
	building_id TEXT, 
	PRIMARY KEY ("Institution_id"), 
	FOREIGN KEY(building_id) REFERENCES building (building_id)
)

/*
2 rows from Institution table:
Institution_id	Institution	Location	Founded	Type	Enrollment	Team	Primary_Conference	building_id
0	Ave Maria University	Ave Maria, Florida	1998.0	Private	1200	Gyrenes	The Sun	1
1	Dakota State University	Madison, South Dakota	1881.0	Public	3102	Trojans	none	1
*/


CREATE TABLE building (
	building_id TEXT, 
	"Name" TEXT, 
	"Street_address" TEXT, 
	"Years_as_tallest" TEXT, 
	"Height_feet" INTEGER, 
	"Floors" INTEGER, 
	PRIMARY KEY (building_id)
)

/*
2 rows from building table:
building_id	Name	Street_address	Years_as_tallest	Height_feet	Floors
0	Citizens Bank Building	701 North Franklin Street	1913–1915	145	12
1	Tampa City Hall	315 John F. Kennedy Boulevard	1915–1926	160	10
*/


CREATE TABLE protein (
	common_name TEXT, 
	protein_name TEXT, 
	divergence_from_human_lineage REAL, 
	accession_number TEXT, 
	sequence_length REAL, 
	sequence_identity_to_human_protein TEXT, 
	"Institution_id" TEXT, 
	PRIMARY KEY (common_name), 
	FOREIGN KEY("Institution_id") REFERENCES "Institution" ("Institution_id")
)

/*
2 rows from protein table:
common_name	protein_name	divergence_from_human_lineage	accession_number	sequence_length	sequence_identity_to_human_protein	Institution_id
Tropical Clawed Frog	uncharacterized protein C20orf117-like	371.2	XP_002942331.1	1584.0	39%	1
purple sea urchin	uncharacterized protein LOC578090	742.9	XP_783370.2	1587.0	47%	3
*/
Show the names and heights of buildings with at least two institutions founded after 1880.
SELECT T1.name ,  T1.height_feet FROM building AS T1 JOIN institution AS T2 ON T1.building_id  =  T2.building_id WHERE T2.founded  >  1880 GROUP BY T1.building_id HAVING count(*)  >=  2
[{'Name': 'Citizens Bank Building', 'Height_feet': 145}, {'Name': 'Tampa City Hall', 'Height_feet': 160}, {'Name': 'One Tampa City Center', 'Height_feet': 537}]