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