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 is the average weight?
assistant
SELECT AVG ( weight ) FROM people;
human
what is the minimum?
assistant
SELECT MIN( weight ) FROM people;
human
show these values for each gender.
assistant
SELECT AVG ( weight ) , MIN( weight ) , sex FROM people GROUP BY sex ;