Table: rockies_2008_game
Columns: date
opponent
score
loss
attendance
record

Question: On what date was the record 39–54?
SQL: SELECT "date" FROM rockies_2008_game WHERE "record" = '39–54'

Question: What was the record on July 1?
SQL: SELECT "record" FROM rockies_2008_game WHERE "date" = 'july 1'