
CREATE TABLE election (
	"Election_ID" INTEGER, 
	"Representative_ID" INTEGER, 
	"Date" TEXT, 
	"Votes" REAL, 
	"Vote_Percent" REAL, 
	"Seats" REAL, 
	"Place" REAL, 
	PRIMARY KEY ("Election_ID"), 
	FOREIGN KEY("Representative_ID") REFERENCES representative ("Representative_ID")
)


CREATE TABLE representative (
	"Representative_ID" INTEGER, 
	"Name" TEXT, 
	"State" TEXT, 
	"Party" TEXT, 
	"Lifespan" TEXT, 
	PRIMARY KEY ("Representative_ID")
)

CREATE TABLE election (
	"Election_ID" INTEGER, 
	"Representative_ID" INTEGER, 
	"Date" TEXT, 
	"Votes" REAL, 
	"Vote_Percent" REAL, 
	"Seats" REAL, 
	"Place" REAL, 
	PRIMARY KEY ("Election_ID"), 
	FOREIGN KEY("Representative_ID") REFERENCES representative ("Representative_ID")
)

/*
2 rows from election table:
Election_ID	Representative_ID	Date	Votes	Vote_Percent	Seats	Place
1	1	July 1942	9423.0	16.2	6.0	3.0
2	2	October 1942	11059.0	18.5	10.0	1.0
*/


CREATE TABLE representative (
	"Representative_ID" INTEGER, 
	"Name" TEXT, 
	"State" TEXT, 
	"Party" TEXT, 
	"Lifespan" TEXT, 
	PRIMARY KEY ("Representative_ID")
)

/*
2 rows from representative table:
Representative_ID	Name	State	Party	Lifespan
1	Dan Quayle	Indiana	Republican	1947–
2	John Quayle	New York	Democratic	1868–1930
*/
List the names of representatives that have not participated in elections listed here.
SELECT Name FROM representative WHERE Representative_ID NOT IN (SELECT Representative_ID FROM election)
[{'Name': 'Al Quie'}, {'Name': 'Jack Quinn'}]