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

How many students are older than average for each gender?
SELECT COUNT(*), sex FROM student WHERE age > (SELECT AVG(age) FROM student) GROUP BY sex
SELECT COUNT(*), "sex" FROM "student" WHERE "age" > (SELECT AVG("age") FROM "student") GROUP BY "sex"