CREATE TABLE table_name_34 (record VARCHAR, date VARCHAR)

What was the record on July 2?
SELECT record FROM table_name_34 WHERE date = "july 2"
SELECT "record" FROM "table_name_34" WHERE "date" = "july 2"