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

What are the types of video games and how many are in each type?
SELECT gtype, COUNT(*) FROM video_games GROUP BY gtype
SELECT "gtype", COUNT(*) FROM "video_games" GROUP BY "gtype"