Schema: CREATE TABLE people (sex VARCHAR, weight INTEGER)
Question: how many people are there whose weight is higher than 85 for each gender?
SQL: SELECT COUNT(*), sex FROM people WHERE weight > 85 GROUP BY sex