CREATE TABLE people (height INT, weight INT, sex VARCHAR)

Find the average height and weight for all males (sex is M).
SELECT AVG(height), AVG(weight) FROM people WHERE sex = 'M'
SELECT AVG("height"), AVG("weight") FROM "people" WHERE "sex" = 'M'