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

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 NULLS LAST