Database: book_press
Question: find the number of authors who are older than 30 for each gender.
SQL:
SELECT count(*) ,  gender FROM author WHERE age  >  30 GROUP BY gender