Show me the attendance of the team_id CH1?
select attendance from home_game where team_id = 'CH1'
Show me the id of the team that has the largest average number of attendance in 2014?
select t2.team_id from home_game as t1 join team as t2 on t1.team_id = t2.team_id where t1.year = 2014 group by t1.team_id order by avg ( t1.attendance ) desc limit 1
Show me the team_id with attendance 3000?
select team_id from home_game where attendance = 3000
Show me the rank of the team that has the largest average number of attendance?
select t2.rank from home_game as t1 join team as t2 on t1.team_id = t2.team_id group by t1.team_id order by avg ( t1.attendance ) desc limit 1