Table: sports_attendance
Columns: league
sport
season
total_attendance
average_attendance

Question: What was the highest average attendance in the 2009 season?
SQL: SELECT MAX("average_attendance") FROM sports_attendance WHERE "season" = '2009'

Question: What's the total attendance in rink hockey when the average attendance was smaller than 4850?
SQL: SELECT "total_attendance" FROM sports_attendance WHERE "average_attendance" < 4850 AND "sport" = 'rink hockey'

Question: What's the average attendance of the league with a total attendance of 2268508?
SQL: SELECT "average_attendance" FROM sports_attendance WHERE "total_attendance" = '2268508'