CREATE TABLE table_name_50 (october NUMBER, record VARCHAR2)

WHich October has a Record of 1 0 0?
SELECT MIN(october) FROM table_name_50 WHERE record = "1–0–0"
SELECT MIN("october") FROM "table_name_50" WHERE "1–0–0" = "record"