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

Show me a scatter plot of major and the total number for .
SELECT Major, COUNT(*) FROM Student GROUP BY Major
SELECT "Major", COUNT(*) FROM "Student" GROUP BY "Major"