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

A bar chart about how many students are older than average for each gender?, and sort by the X-axis from high to low please.
SELECT Sex, COUNT(*) FROM Student WHERE Age > (SELECT AVG(Age) FROM Student) GROUP BY Sex ORDER BY Sex DESC
SELECT "Sex", COUNT(*) FROM "Student" WHERE "Age" > (SELECT AVG("Age") FROM "Student") GROUP BY "Sex" ORDER BY "Sex" DESC