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

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