CREATE TABLE candidate (Candidate_ID INT, People_ID INT, Poll_Source TEXT, Date TEXT, Support_rate FLOAT, Consider_rate FLOAT, Oppose_rate FLOAT, Unsure_rate FLOAT)
CREATE TABLE people (People_ID INT, Sex TEXT, Name TEXT, Date_of_Birth TEXT, Height FLOAT, Weight FLOAT)

Draw a bar chart about the distribution of Sex and the average of Weight , and group by attribute Sex, I want to rank in asc by the y-axis.
SELECT Sex, AVG(Weight) FROM people GROUP BY Sex ORDER BY AVG(Weight)
SELECT "Sex", AVG("Weight") FROM "people" GROUP BY "Sex" ORDER BY AVG("Weight") NULLS FIRST