Table: red_sox_2006_game
Columns: date
opponent
score
loss
attendance
record

Question: Who did the Red Sox play against on July 8?
SQL: SELECT "opponent" FROM red_sox_2006_game WHERE "date" = 'july 8'