Database: video_game
Question: How many games are there from each Franchise?
SQL:
SELECT Franchise ,  COUNT(*) FROM game GROUP BY Franchise