SELECT Sex, SUM(Weight) FROM people GROUP BY Sex ORDER BY SUM(Weight) DESC
Find Sex and the sum of Weight , and group by attribute Sex, and visualize them by a bar chart, sort by the Y in descending.
CREATE TABLE people (
    People_ID int,
    Sex text,
    Name text,
    Date_of_Birth text,
    Height real,
    Weight real
)

CREATE TABLE candidate (
    Candidate_ID int,
    People_ID int,
    Poll_Source text,
    Date text,
    Support_rate real,
    Consider_rate real,
    Oppose_rate real,
    Unsure_rate real
)