CREATE TABLE table_name_72 (record VARCHAR, date VARCHAR)

What was the record as of September 1?
SELECT record FROM table_name_72 WHERE date = "september 1"
SELECT "record" FROM "table_name_72" WHERE "date" = "september 1"