What are the different types of video games?
select gtype from video_games
For each type, what information is there on the games?
select * from video_games group by gtype
How many games are there for each type?
select gtype, count(*) from video_games group by gtype