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

List how many students in each last name who majored in 600 using a bar chart.
SELECT LName, COUNT(LName) FROM Student WHERE Major = 600 GROUP BY LName
SELECT "LName", COUNT("LName") FROM "Student" WHERE "Major" = 600 GROUP BY "LName"