Database: book_press
Question: How many authors are of age above 30 for each gender?
SQL:
SELECT count(*) ,  gender FROM author WHERE age  >  30 GROUP BY gender