CREATE TABLE table_name_87 (record VARCHAR2, date VARCHAR2)

What was the record on July 28?
SELECT record FROM table_name_87 WHERE date = "july 28"
SELECT "record" FROM "table_name_87" WHERE "date" = "july 28"