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 people have a weight that is higher than 85?
assistant
SELECT COUNT( * ) FROM people WHERE weight > 85;
human
Out of those 6 people, how many of them are female?
assistant
SELECT COUNT( * ) FROM people WHERE weight > 85 AND Sex = 'F';
human
How many of them are male?
assistant
SELECT COUNT( * ) FROM people WHERE weight > 85 AND Sex = "M" ;