CREATE TABLE Has_Allergy (StuID NUMBER, Allergy VARCHAR2)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)
CREATE TABLE Allergy_Type (Allergy VARCHAR2, AllergyType VARCHAR2)

What are the average ages for male and female students Plot them as bar chart, and could you rank by the bars in desc?
SELECT Sex, AVG(Age) FROM Student GROUP BY Sex ORDER BY Sex DESC
SELECT "Sex", AVG("Age") FROM "Student" GROUP BY "Sex" ORDER BY "Sex" DESC