
CREATE TABLE candidate (
	"Candidate_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Poll_Source" TEXT, 
	"Date" TEXT, 
	"Support_rate" REAL, 
	"Consider_rate" REAL, 
	"Oppose_rate" REAL, 
	"Unsure_rate" REAL, 
	PRIMARY KEY ("Candidate_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)


CREATE TABLE people (
	"People_ID" INTEGER, 
	"Sex" TEXT, 
	"Name" TEXT, 
	"Date_of_Birth" TEXT, 
	"Height" REAL, 
	"Weight" REAL, 
	PRIMARY KEY ("People_ID")
)

CREATE TABLE candidate (
	"Candidate_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Poll_Source" TEXT, 
	"Date" TEXT, 
	"Support_rate" REAL, 
	"Consider_rate" REAL, 
	"Oppose_rate" REAL, 
	"Unsure_rate" REAL, 
	PRIMARY KEY ("Candidate_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)

/*
2 rows from candidate table:
Candidate_ID	People_ID	Poll_Source	Date	Support_rate	Consider_rate	Oppose_rate	Unsure_rate
1	1	WNBC/Marist Poll	Feb 12–15, 2007	0.25	0.3	0.43	0.2
2	3	WNBC/Marist Poll	Feb 12–15, 2007	0.17	0.42	0.32	0.9
*/


CREATE TABLE people (
	"People_ID" INTEGER, 
	"Sex" TEXT, 
	"Name" TEXT, 
	"Date_of_Birth" TEXT, 
	"Height" REAL, 
	"Weight" REAL, 
	PRIMARY KEY ("People_ID")
)

/*
2 rows from people table:
People_ID	Sex	Name	Date_of_Birth	Height	Weight
1	M	Hubert Henno	06.10.1976	188.0	83.0
2	M	Dominique Daquin	10.11.1972	197.0	85.0
*/
Find the id of the candidate who got the lowest oppose rate.
SELECT Candidate_ID FROM candidate ORDER BY oppose_rate LIMIT 1
[{'Candidate_ID': 2}]