Database: dorm_1
Question: How many students are older than average for each gender?
SQL:
SELECT count(*) ,  sex FROM student WHERE age  >  (SELECT avg(age) FROM student) GROUP BY sex