CREATE TABLE student (sex VARCHAR2, age NUMBER)

Find the average and oldest age for students with different sex.
SELECT AVG(age), MAX(age), sex FROM student GROUP BY sex
SELECT AVG("age"), MAX("age"), "sex" FROM "student" GROUP BY "sex"