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)
CREATE TABLE people (People_ID NUMBER, Sex CLOB, Name CLOB, Date_of_Birth CLOB, Height FLOAT, Weight FLOAT)

Return a bar chart about the distribution of Sex and the amount of Sex , and group by attribute Sex, could you order by the Y-axis in asc?
SELECT Sex, COUNT(Sex) FROM people GROUP BY Sex ORDER BY COUNT(Sex)
SELECT "Sex", COUNT("Sex") FROM "people" GROUP BY "Sex" ORDER BY COUNT("Sex")