Find the number of people who is under 40 for each gender.
SELECT count(*) ,  gender FROM Person WHERE age  <  40 GROUP BY gender
SELECT count(*) ,  gender FROM Person WHERE age  <  40 GROUP BY gender
[{'count(*)': 2, 'gender': 'female'}, {'count(*)': 1, 'gender': 'male'}]