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
[{'id': 1, 'count(*)': 2}, {'id': 2, 'count(*)': 2}, {'id': 3, 'count(*)': 2}, {'id': 4, 'count(*)': 2}, {'id': 5, 'count(*)': 2}, {'id': 6, 'count(*)': 1}, {'id': 7, 'count(*)': 2}, {'id': 8, 'count(*)': 1}, {'id': 9, 'count(*)': 1}, {'id': 10, 'count(*)': 3}, {'id': 11, 'count(*)': 1}, {'id': 12, 'count(*)': 1}]