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

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