How many games has each stadium held?
select t1.id, count ( * ) from stadium as t1 join game as t2 on t1.id = t2.stadium_id group by t1.id
So how many total games were there?
select count ( * ) from game