What is the total home game attendance of team Cleveland Forest Citys?
select sum(t1.attendance) from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br where t2.name = 'Cleveland forest Citys'
How about the number for Boston Red Stockings?
select sum(t1.attendance) from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br where t2.name = 'Boston red Stockings'
Can you please give the results for 2005?
select sum(t1.attendance) from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br where t2.name = 'Boston red Stockings' and t1.year = 2005;
How about the number from 2000 to 2010?
select sum(t1.attendance) from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br where t2.name = 'Boston red Stockings' and t1.year between 2000 and 2010;