CREATE TABLE table_55042 ("Date" CLOB, "Opponent" CLOB, "Score" CLOB, "Loss" CLOB, "Record" CLOB)

What was the record as of September 1?
SELECT "Record" FROM table_55042 WHERE "Date" = 'september 1'
SELECT "Record" FROM "table_55042" WHERE "Date" = 'september 1'