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)

Show the average age for all female students and group them by last name with a bar chart, and could you order the average of age in desc order?
SELECT LName, AVG(Age) FROM Student WHERE Sex = 'F' GROUP BY LName ORDER BY AVG(Age) DESC
SELECT "LName", AVG("Age") FROM "Student" WHERE "Sex" = 'F' GROUP BY "LName" ORDER BY AVG("Age") DESC