SCHEMA:
CREATE TABLE Person (gender VARCHAR, age INTEGER)
USER:
Find the number of people who is under 40 for each gender.

QUERY:
SELECT COUNT(*), gender FROM Person WHERE age < 40 GROUP BY gender