Table: game_stats_2006
Columns: date
opponent
score
loss
attendance
record

Question: What was the attendance at the Red Sox game that had a loss of Wakefield (7–10)?
SQL: SELECT "attendance" FROM game_stats_2006 WHERE "loss" = 'wakefield (7–10)'

Question: What was the loss of the Red Sox game when they had a record of 77–67?
SQL: SELECT "loss" FROM game_stats_2006 WHERE "record" = '77–67'