CREATE TABLE people (sex VARCHAR, weight INT)

how many people are there whose weight is higher than 85 for each gender?
SELECT COUNT(*), sex FROM people WHERE weight > 85 GROUP BY sex
SELECT COUNT(*), "sex" FROM "people" WHERE "weight" > 85 GROUP BY "sex"