Which park is located in Atlanta?
select park_name from park where city = 'Atlanta'
How many games were played in this city?
select count(*) from home_game as t1 join park as t2 on t1.park_id = t2.park_id where t2.city = 'Atlanta';
How about the number in 2010?
select count(*) from home_game as t1 join park as t2 on t1.park_id = t2.park_id where t1.year = 2010 and t2.city = 'Atlanta';
How about the number in 2000?
select count(*) from home_game as t1 join park as t2 on t1.park_id = t2.park_id where t1.year = 2000 and t2.city = 'Atlanta';