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

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"