How many people are 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'}]