human
Schema:
candidate (Candidate_ID, People_ID, Poll_Source, Date, Support_rate, Consider_rate, Oppose_rate, Unsure_rate)
people (People_ID, Sex, Name, Date_of_Birth, Height, Weight)
Please answer with SQL.
assistant
Sure, I understand.
human
Can you show me the top three highest support rates for the candidates?
assistant
SELECT support_rate FROM candidate ORDER BY support_rate DESC LIMIT 3;
human
What polls are those from? | Did you want the poll source for these polls? | Yes, please
assistant
SELECT Poll_Source , Support_rate FROM candidate ORDER BY support_rate DESC LIMIT 3;
human
What is the name of the poll source with the earliest date?
assistant
SELECT Poll_Source FROM candidate ORDER BY Date DESC LIMIT 1 ;