
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
*/
List all info about all people.
SELECT * FROM people
[{'People_ID': 1, 'Sex': 'M', 'Name': 'Hubert Henno', 'Date_of_Birth': '06.10.1976', 'Height': 188.0, 'Weight': 83.0}, {'People_ID': 2, 'Sex': 'M', 'Name': 'Dominique Daquin', 'Date_of_Birth': '10.11.1972', 'Height': 197.0, 'Weight': 85.0}, {'People_ID': 3, 'Sex': 'F', 'Name': 'Stéphane Antiga', 'Date_of_Birth': '03.02.1976', 'Height': 200.0, 'Weight': 94.0}, {'People_ID': 4, 'Sex': 'M', 'Name': 'Laurent Capet', 'Date_of_Birth': '05.05.1972', 'Height': 202.0, 'Weight': 92.0}, {'People_ID': 5, 'Sex': 'F', 'Name': 'Frantz Granvorka', 'Date_of_Birth': '10.03.1976', 'Height': 195.0, 'Weight': 90.0}, {'People_ID': 6, 'Sex': 'M', 'Name': 'Vincent Montméat', 'Date_of_Birth': '01.09.1977', 'Height': 196.0, 'Weight': 88.0}, {'People_ID': 7, 'Sex': 'M', 'Name': 'Loïc De Kergret', 'Date_of_Birth': '20.08.1970', 'Height': 193.0, 'Weight': 89.0}, {'People_ID': 8, 'Sex': 'M', 'Name': 'Philippe Barça-Cysique', 'Date_of_Birth': '22.04.1977', 'Height': 194.0, 'Weight': 88.0}, {'People_ID': 9, 'Sex': 'M', 'Name': 'Guillaume Samica', 'Date_of_Birth': '28.09.1981', 'Height': 196.0, 'Weight': 82.0}]