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

Show me about the distribution of Sex and the sum of Weight , and group by attribute Sex in a bar chart, rank total number of weight in desc order.
SELECT Sex, SUM(Weight) FROM people GROUP BY Sex ORDER BY SUM(Weight) DESC
SELECT "Sex", SUM("Weight") FROM "people" GROUP BY "Sex" ORDER BY SUM("Weight") DESC