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
Hello, how many candidates total are there?
assistant
SELECT COUNT( * ) FROM candidate;
human
Perfect, and who has the highest support percentage? | Do you want the people id? | Actually, just the percentage please.
assistant
SELECT MAX( support_rate ) FROM candidate;
human
Perfect, what about the lowest consider rate?
assistant
SELECT MIN( consider_rate ) FROM candidate;
human
And what about the lowest oppose rate?
assistant
SELECT MIN( Oppose_rate ) FROM candidate ;