CREATE TABLE video_games (gameid DECIMAL, gname TEXT, gtype TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE plays_games (stuid DECIMAL, gameid DECIMAL, hours_played DECIMAL)
CREATE TABLE sportsinfo (stuid DECIMAL, sportname TEXT, hoursperweek DECIMAL, gamesplayed DECIMAL, onscholarship TEXT)

What are the average, minimum, and max ages for each of the different majors?
SELECT major, AVG(age), MIN(age), MAX(age) FROM student GROUP BY major
SELECT "major", AVG("age"), MIN("age"), MAX("age") FROM "student" GROUP BY "major"