CREATE TABLE Allergy_Type (Allergy VARCHAR2, AllergyType VARCHAR2)
CREATE TABLE Has_Allergy (StuID NUMBER, Allergy VARCHAR2)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)

Show all majors and corresponding number of students by a scatter chart.
SELECT Major, COUNT(*) FROM Student GROUP BY Major
SELECT "Major", COUNT(*) FROM "Student" GROUP BY "Major"