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

A bar chart showing the number of last name for all female students Their sex is F, list by the the number of lname in desc please.
SELECT LName, COUNT(LName) FROM Student WHERE Sex = 'F' GROUP BY LName ORDER BY COUNT(LName) DESC
SELECT "LName", COUNT("LName") FROM "Student" WHERE "Sex" = 'F' GROUP BY "LName" ORDER BY COUNT("LName") DESC