CREATE TABLE Has_Allergy (StuID NUMBER, Allergy VARCHAR2)
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)

A bar chart about the number of first name for all female students whose sex is F, list by the x-axis in descending.
SELECT Fname, COUNT(Fname) FROM Student WHERE Sex = 'F' GROUP BY Fname ORDER BY Fname DESC
SELECT "Fname", COUNT("Fname") FROM "Student" WHERE "Sex" = 'F' GROUP BY "Fname" ORDER BY "Fname" DESC