SELECT count(*) FROM candidate
How many candidates are there?
CREATE TABLE "candidate" (
"Candidate_ID" int,
"People_ID" int,
"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" int,
"Sex" text,
"Name" text,
"Date_of_Birth" text,
"Height" real,
"Weight" real,
PRIMARY KEY ("People_ID")
);
INSERT INTO  "people" VALUES (1,"M","Hubert Henno","06.10.1976","188","83");
INSERT INTO  "candidate" VALUES (1,1,"WNBC/Marist Poll","Feb 12–15, 2007","0.25","0.30","0.43","0.2");