CREATE TABLE Visits_Restaurant (StuID NUMBER, ResID NUMBER, Time TIMESTAMP, Spent FLOAT)
CREATE TABLE Type_Of_Restaurant (ResID NUMBER, ResTypeID NUMBER)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)
CREATE TABLE Restaurant_Type (ResTypeID NUMBER, ResTypeName VARCHAR2, ResTypeDescription VARCHAR2)
CREATE TABLE Restaurant (ResID NUMBER, ResName VARCHAR2, Address VARCHAR2, Rating NUMBER)

For those female students with age is older than 18 who are not majoring in 600, tell me how many students of different first names using a bar chart, rank by the how many fname in desc please.
SELECT Fname, COUNT(Fname) FROM Student WHERE Age > 18 AND Major <> 600 AND Sex = 'F' GROUP BY Fname ORDER BY COUNT(Fname) DESC
SELECT "Fname", COUNT("Fname") FROM "Student" WHERE "Age" > 18 AND "Major" <> 600 AND "Sex" = 'F' GROUP BY "Fname" ORDER BY COUNT("Fname") DESC