Show all video game types and the number of video games in each type.
CREATE TABLE Video_games (gtype VARCHAR)
SELECT gtype, COUNT(*) FROM Video_games GROUP BY gtype
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Video_games (gtype VARCHAR) Question: Show all video game types and the number of video games in each type. [/INST] SELECT gtype, COUNT(*) FROM Video_games GROUP BY gtype </s>