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

A bar chart showing the number of first name for all female students Their sex is F, and show total number from low to high order.
SELECT Fname, COUNT(Fname) FROM Student WHERE Sex = 'F' GROUP BY Fname ORDER BY COUNT(Fname)
SELECT "Fname", COUNT("Fname") FROM "Student" WHERE "Sex" = 'F' GROUP BY "Fname" ORDER BY COUNT("Fname")