Database: dorm_1
Question: What is the average and oldest age for each gender of student?
SQL:
SELECT avg(age) ,  max(age) ,  sex FROM student GROUP BY sex