CREATE TABLE table_name_47 (loss VARCHAR2, date VARCHAR2)

What loss has october 1 as the date?
SELECT loss FROM table_name_47 WHERE date = "october 1"
SELECT "loss" FROM "table_name_47" WHERE "date" = "october 1"