user: ### NOW ANSWER:
Question: What was the total attendance at Rugby Park?
Columns: ['Team', 'Stadium', 'Capacity', 'Total', 'Highest', 'Lowest', 'Average']
Types: ['text', 'text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Aberdeen', 'Pittodrie Stadium', 22199.0, 173460.0, 15307.0, 5955.0, 9129.0]
SQL:

assistant: SELECT "Total" FROM "Table" WHERE "Stadium" = 'Rugby Park';