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)

What are the average height and weight across males (sex is M)?
SELECT AVG(height), AVG(weight) FROM people WHERE sex = 'M'
SELECT AVG("height"), AVG("weight") FROM "people" WHERE "sex" = 'M'