user: Question: How many were in attendance on 14 April 2007?
Columns: ['Date', 'Opponent', 'Venue', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['19 August 2006', 'Wigan Athletic', 'Home', '2-1', 51569.0]
SQL:

assistant: SELECT SUM("Attendance") FROM "Table" WHERE "Date" = '14 April 2007';