CREATE TABLE table_7176 ("Year" FLOAT, "League" CLOB, "Average Attendance" FLOAT, "# of Home Games" FLOAT, "League Rank" CLOB, "Canada - USA Rank" CLOB)

Before 2012, what was the greatest # of Home Games with a Canada - USA Rank of 52nd, and an Average Attendance less than 992?
SELECT MAX("# of Home Games") FROM table_7176 WHERE "Year" < '2012' AND "Canada - USA Rank" = '52nd' AND "Average Attendance" < '992'
SELECT MAX("# of Home Games") FROM "table_7176" WHERE "Average Attendance" < '992' AND "Canada - USA Rank" = '52nd' AND "Year" < '2012'