CREATE TABLE Allergy_Type (Allergy VARCHAR2, AllergyType VARCHAR2)
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)

A bar chart about the number of last name for all female students whose sex is F, could you sort in descending by the X?
SELECT LName, COUNT(LName) FROM Student WHERE Sex = 'F' GROUP BY LName ORDER BY LName DESC
SELECT "LName", COUNT("LName") FROM "Student" WHERE "Sex" = 'F' GROUP BY "LName" ORDER BY "LName" DESC