The sum of attendance of a team in its home game
select t2.name from home_game as t1 join team as t2 on t1.team_id = t2.team_id_br group by t1.team_id order by sum ( t1.attendance ) asc limit 1
The attendance in home games for Altoona Mountain City
select sum ( t1.attendance ) from home_game as t1 join team as t2 on t1.team_id = t2.team_id group by t1.team_id order by sum ( t1.attendance ) asc limit 1
Which team had the highest number of attendance?
select t2.name from home_game as t1 join team as t2 on t1.team_id = t2.team_id group by t1.team_id order by sum ( t1.attendance ) desc limit 1
* I have left the chat *
select sum ( t1.attendance ) from home_game as t1 join team as t2 on t1.team_id = t2.team_id group by t1.team_id order by sum ( t1.attendance ) desc limit 1