CREATE TABLE candidate (Candidate_ID INT, People_ID INT, Poll_Source TEXT, Date TEXT, Support_rate FLOAT, Consider_rate FLOAT, Oppose_rate FLOAT, Unsure_rate FLOAT)
CREATE TABLE people (People_ID INT, Sex TEXT, Name TEXT, Date_of_Birth TEXT, Height FLOAT, Weight FLOAT)

Scatter plot to show consider rate on x axis and oppose_rate on y axis.
SELECT Consider_rate, Oppose_rate FROM candidate
SELECT "Consider_rate", "Oppose_rate" FROM "candidate"