CREATE TABLE Dorm_amenity (amenid INT, amenity_name VARCHAR)
CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Lives_in (stuid INT, dormid INT, room_number INT)
CREATE TABLE Has_amenity (dormid INT, amenid INT)
CREATE TABLE Dorm (dormid INT, dorm_name VARCHAR, student_capacity INT, gender VARCHAR)

Bar graph to show maximal age from different sex, and could you list Sex from high to low order?
SELECT Sex, MAX(Age) FROM Student GROUP BY Sex ORDER BY Sex DESC
SELECT "Sex", MAX("Age") FROM "Student" GROUP BY "Sex" ORDER BY "Sex" DESC NULLS LAST