Table: afl_2000_season_stats
Columns: venue
hosted
average
highest
lowest
total
last_year
up_down

Question: What is the maximum average associated with a total of 221902?
SQL: SELECT MAX("average") FROM afl_2000_season_stats WHERE "total" = 221902

Question: How many values of hosted have a highest value of 42659?
SQL: SELECT COUNT("hosted") FROM afl_2000_season_stats WHERE "highest" = 42659

Question: How many values of up/down have a total value of exactly 301470?
SQL: SELECT COUNT("up_down") FROM afl_2000_season_stats WHERE "total" = 301470

Question: What is the up/down associated with the Subiaco Oval?
SQL: SELECT "up_down" FROM afl_2000_season_stats WHERE "venue" = 'Subiaco Oval'