Table schema:
CREATE TABLE table_name_87 (record VARCHAR, date VARCHAR)

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