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
How many poll sources are there?
assistant
SELECT COUNT( Poll_Source ) FROM candidate;
human
how many people are there?
assistant
SELECT COUNT( people_id ) FROM people;
human
And how many are female? | Do you mean the people who are female? | Yes, how many are female, have gender 'F'
assistant
SELECT COUNT( * ) FROM people WHERE sex = 'F';
human
what is their unsure rate? | Do you mean the unsure rate of the people who are female? | Yes
assistant
SELECT t2.Unsure_rate FROM people AS t1 JOIN candidate AS t2 ON t1.people_id = t2.people_id WHERE t1.sex = "F" ;