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

A bar chart about the number of last name for all female students whose sex is F, and rank in asc by the y-axis.
SELECT LName, COUNT(LName) FROM Student WHERE Sex = 'F' GROUP BY LName ORDER BY COUNT(LName)
SELECT "LName", COUNT("LName") FROM "Student" WHERE "Sex" = 'F' GROUP BY "LName" ORDER BY COUNT("LName") NULLS FIRST