
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 of buildings except for those having an institution founded in 2003.
SELECT name FROM building EXCEPT SELECT T1.name FROM building AS T1 JOIN institution AS T2 ON T1.building_id  =  T2.building_id WHERE T2.founded  =  2003
[{'Name': '100 North Tampa'}, {'Name': 'Bank of America Tower'}, {'Name': 'Floridan Hotel'}, {'Name': 'Franklin Exchange Building'}, {'Name': 'One Tampa City Center'}, {'Name': 'Park Tower'}, {'Name': 'Tampa City Hall'}]