What is the total home game attendance of all teams 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 t1.year between 2000 and 2010
What about for just the team 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' and t1.year between 2000 and 2010
What's the average total home game attendance for the Cleveland Forest Citys for all years?
select avg ( 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'
What about for the Chicago White Stockings?
select avg ( t1.attendance ) from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br where t2.name = 'Chicago white Stockings'
What is the name of the team with the earliest home game date, and what is that date?
select t2.name,t1.span_first from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br order by t1.span_first limit 1
What about the latest date?
select t2.name,t1.span_first from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br order by t1.span_first desc limit 1