CREATE TABLE Plays_Games (StuID INT, GameID INT, Hours_Played INT)
CREATE TABLE SportsInfo (StuID INT, SportName VARCHAR, HoursPerWeek INT, GamesPlayed INT, OnScholarship VARCHAR)
CREATE TABLE Video_Games (GameID INT, GName VARCHAR, GType VARCHAR)
CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)

Scatter plot to show min(age) on x axis and maximal age on y axis for different majors.
SELECT MIN(Age), MAX(Age), Major FROM Student GROUP BY Major
SELECT MIN("Age"), MAX("Age"), "Major" FROM "Student" GROUP BY "Major"