CREATE TABLE table_name_26 (record VARCHAR2, date VARCHAR2)

What was the record on September 4?
SELECT record FROM table_name_26 WHERE date = "september 4"
SELECT "record" FROM "table_name_26" WHERE "date" = "september 4"