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)

Show all video games and their types in the order of their names.
SELECT gname, gtype FROM video_games ORDER BY gname
SELECT "gname", "gtype" FROM "video_games" ORDER BY "gname" NULLS FIRST