Schema: CREATE TABLE student (sex VARCHAR, age INTEGER)
Question: Find the average and oldest age for students with different sex.
SQL: SELECT AVG(age), MAX(age), sex FROM student GROUP BY sex