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)

A bar chart showing the minimum weight for each gender, and I want to list by the bar in ascending.
SELECT Sex, MIN(Weight) FROM people GROUP BY Sex ORDER BY Sex
SELECT "Sex", MIN("Weight") FROM "people" GROUP BY "Sex" ORDER BY "Sex"