Database: dorm_1
Question: Find the average and oldest age for students with different sex.
SQL:
SELECT avg(age) ,  max(age) ,  sex FROM student GROUP BY sex