user: Question: How many in total were in attendance at games where Chelsea was the away team?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['1', 'Bristol City', '1 – 1', 'Kingstonian', 14787.0]
SQL:

assistant: SELECT SUM("Attendance") FROM "Table" WHERE "Away team" = 'Chelsea';