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
What are the top 3 highest support rates?
assistant
SELECT support_rate FROM candidate ORDER BY support_rate DESC LIMIT 3;
human
What are the poll sources of those support rates?
assistant
SELECT Poll_Source FROM candidate ORDER BY support_rate DESC LIMIT 3;
human
What are the dates for those support rates?
assistant
SELECT Date FROM candidate ORDER BY support_rate DESC LIMIT 3;
human
What's the unsure rate of those?
assistant
SELECT Unsure_rate FROM candidate ORDER BY support_rate DESC LIMIT 3;
human
What are the consider rates of those?
assistant
SELECT Consider_rate FROM candidate ORDER BY support_rate DESC LIMIT 3 ;