Schema: CREATE TABLE Person (gender VARCHAR, age INTEGER)
Question: Find the number of people who is under 40 for each gender.
SQL: SELECT COUNT(*), gender FROM Person WHERE age < 40 GROUP BY gender