CREATE TABLE Has_amenity (dormid INT, amenid INT)
CREATE TABLE Dorm_amenity (amenid INT, amenity_name VARCHAR)
CREATE TABLE Dorm (dormid INT, dorm_name VARCHAR, student_capacity INT, gender 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)

Bar graph to show maximal age from different sex, could you order by the Y in asc?
SELECT Sex, MAX(Age) FROM Student GROUP BY Sex ORDER BY MAX(Age)
SELECT "Sex", MAX("Age") FROM "Student" GROUP BY "Sex" ORDER BY MAX("Age") NULLS FIRST