CREATE TABLE table_name_1 (attendance NUMBER, date VARCHAR2)

What was the lowest Attendance on 8 October 1986?
SELECT MIN(attendance) FROM table_name_1 WHERE date = "8 october 1986"
SELECT MIN("attendance") FROM "table_name_1" WHERE "8 october 1986" = "date"