CREATE TABLE table_name_23 (record VARCHAR2, date VARCHAR2)

Which Record is on july 31?
SELECT record FROM table_name_23 WHERE date = "july 31"
SELECT "record" FROM "table_name_23" WHERE "date" = "july 31"