Database: video_game
Question: List the name of each franchise and the number of games belonging to that franchise.
SQL:
SELECT Franchise ,  COUNT(*) FROM game GROUP BY Franchise