Table: athletics_2006_game
Columns: date
opponent
score
loss
attendance
record

Question: What is the attendance for august 29?
SQL: SELECT "attendance" FROM athletics_2006_game WHERE "date" = 'august 29'

Question: Which loss has an Opponent of @ angels, and a Date of august 1?
SQL: SELECT "loss" FROM athletics_2006_game WHERE "opponent" = '@ angels' AND "date" = 'august 1'

Question: Which score has an Attendance of 31,178?
SQL: SELECT "score" FROM athletics_2006_game WHERE "attendance" = '31,178'

Question: Which record has a Date of august 28?
SQL: SELECT "record" FROM athletics_2006_game WHERE "date" = 'august 28'

Question: Which loss has an Attendance of 23,952?
SQL: SELECT "loss" FROM athletics_2006_game WHERE "attendance" = '23,952'

Question: Which opponent has a Loss of corcoran (4-4)?
SQL: SELECT "opponent" FROM athletics_2006_game WHERE "loss" = 'corcoran (4-4)'