Show me the name of all the stadiums.
select name from stadium
How many games has each of them held?
select t1.name, count(*) from stadium as t1 join game as t2 on t1.id = t2.stadium_id group by t1.id