CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE dorm_amenity (amenid NUMBER, amenity_name CLOB)
CREATE TABLE lives_in (stuid NUMBER, dormid NUMBER, room_number NUMBER)
CREATE TABLE has_amenity (dormid NUMBER, amenid NUMBER)
CREATE TABLE dorm (dormid NUMBER, dorm_name CLOB, student_capacity NUMBER, gender CLOB)

What is the average and oldest age for each gender of student?
SELECT AVG(age), MAX(age), sex FROM student GROUP BY sex
SELECT AVG("age"), MAX("age"), "sex" FROM "student" GROUP BY "sex"