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

List how many students in each last name who majored in 600 using a bar chart, and I want to rank by the Y in desc.
SELECT LName, COUNT(LName) FROM Student WHERE Major = 600 GROUP BY LName ORDER BY COUNT(LName) DESC
SELECT "LName", COUNT("LName") FROM "Student" WHERE "Major" = 600 GROUP BY "LName" ORDER BY COUNT("LName") DESC