Table: red_sox_1967_games
Columns: date
opponent
score
loss
record

Question: What was the record at the game that had a loss of Brandon (4–8)?
SQL: SELECT "record" FROM red_sox_1967_games WHERE "loss" = 'brandon (4–8)'

Question: What was the loss of the game with a record of 54–42?
SQL: SELECT "loss" FROM red_sox_1967_games WHERE "record" = '54–42'

Question: Who was the opponent at the game that had a loss of Bell (6–9)?
SQL: SELECT "opponent" FROM red_sox_1967_games WHERE "loss" = 'bell (6–9)'

Question: What was the record at the game that had a loss of Wyatt (4–4)?
SQL: SELECT "record" FROM red_sox_1967_games WHERE "loss" = 'wyatt (4–4)'