user: Question: WHat is tHe total of attendance at Venue H wHen Auxerre were playing?
Columns: ['Date', 'Round', 'Opponent', 'Venue', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text', 'real']
Sample row: ['7 August 1996', 'QR', 'Alania Vladikavkaz', 'H', '3–1', 44799.0]
SQL:

assistant: SELECT SUM("Attendance") FROM "Table" WHERE "Venue" = 'H' AND "Opponent" = 'Auxerre';