user: ### NOW ANSWER:
Question: Before 2012, what was the greatest # of Home Games with a Canada - USA Rank of 52nd, and an Average Attendance less than 992?
Columns: ['Year', 'League', 'Average Attendance', '# of Home Games', 'League Rank', 'Canada - USA Rank']
Types: ['real', 'text', 'real', 'real', 'text', 'text']
Sample row: [2009.0, 'USL-PDL', 1734.0, 9.0, '4th', '39th']
SQL:

assistant: SELECT MAX("# of Home Games") FROM "Table" WHERE "Year" < 2012.0 AND "Canada - USA Rank" = '52nd' AND "Average Attendance" < 992.0;