CREATE TABLE people (people_id NUMBER, sex CLOB, name CLOB, date_of_birth CLOB, height NUMBER, weight NUMBER)
CREATE TABLE candidate (candidate_id NUMBER, people_id NUMBER, poll_source CLOB, date CLOB, support_rate NUMBER, consider_rate NUMBER, oppose_rate NUMBER, unsure_rate NUMBER)

Find the average and minimum weight for each gender.
SELECT AVG(weight), MIN(weight), sex FROM people GROUP BY sex
SELECT AVG("weight"), MIN("weight"), "sex" FROM "people" GROUP BY "sex"