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

For the attribute Sex and the amount of Sex, show their proportion by a pie chart.
SELECT Sex, COUNT(Sex) FROM people GROUP BY Sex
SELECT "Sex", COUNT("Sex") FROM "people" GROUP BY "Sex"