SELECT T1.id ,  count(*) FROM stadium AS T1 JOIN game AS T2 ON T1.id  =  T2.stadium_id GROUP BY T1.id
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
select t1 . id , count ( * ) from stadium as t1 join game as t2 on t1 . id = t2 . stadium_id group by t1 . id
How many games has each stadium held ?