CREATE TABLE Dorm (dormid INT, dorm_name VARCHAR, student_capacity INT, gender VARCHAR)
CREATE TABLE Dorm_amenity (amenid INT, amenity_name VARCHAR)
CREATE TABLE Has_amenity (dormid INT, amenid INT)
CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Lives_in (stuid INT, dormid INT, room_number INT)

Return a scatter chart on how many students are there in each major?
SELECT COUNT(*), Major FROM Student GROUP BY Major
SELECT COUNT(*), "Major" FROM "Student" GROUP BY "Major"