Table: highlanders_stats
Columns: year
league
average_attendance
of_home_games
league_rank
canada_usa_rank

Question: What was the Average Attendance during the Year in which there were 9 Home Games?
SQL: SELECT MAX("average_attendance") FROM highlanders_stats WHERE "of_home_games" = 9

Question: Before 2012, what was the greatest # of Home Games with a Canada - USA Rank of 52nd, and an Average Attendance less than 992?
SQL: SELECT MAX("of_home_games") FROM highlanders_stats WHERE "year" < 2012 AND "canada_usa_rank" = '52nd' AND "average_attendance" < 992

Question: In the year where the League Rank was 10th, what was the greatest number of Home Games?
SQL: SELECT MAX("of_home_games") FROM highlanders_stats WHERE "league_rank" = '10th'

Question: After the year 2011, when the Canada - USA Rank was 46th, what was the League Rank?
SQL: SELECT "league_rank" FROM highlanders_stats WHERE "year" > 2011 AND "canada_usa_rank" = '46th'