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)

List how many students in each last name who majored in 600 using a bar chart, and show names from high to low order.
SELECT LName, COUNT(LName) FROM Student WHERE Major = 600 GROUP BY LName ORDER BY LName DESC
SELECT "LName", COUNT("LName") FROM "Student" WHERE "Major" = 600 GROUP BY "LName" ORDER BY "LName" DESC