Table: game_results_07
Columns: date
opponent
home_away
field
result

Question: Was the game against the Rattlers at the United Sports Training Center a home game or an away game?
SQL: SELECT "home_away" FROM game_results_07 WHERE "opponent" = 'rattlers' AND "field" = 'united sports training center'

Question: What was the opponent for the game at Multi-sport Field?
SQL: SELECT "opponent" FROM game_results_07 WHERE "field" = 'multi-sport field'

Question: What is the result of the away game played on August 4?
SQL: SELECT "result" FROM game_results_07 WHERE "home_away" = 'away' AND "date" = 'august 4'

Question: On which field was the game played on July 12?
SQL: SELECT "field" FROM game_results_07 WHERE "date" = 'july 12'