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

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"