How many students are older than average for each gender?
SELECT count(*) ,  sex FROM student WHERE age  >  (SELECT avg(age) FROM student) GROUP BY sex
SELECT count(*) ,  sex FROM student WHERE age  >  (SELECT avg(age) FROM student) GROUP BY sex
[{'count(*)': 5, 'Sex': 'F'}, {'count(*)': 10, 'Sex': 'M'}]