Table: game_results_2006
Columns: date
opponent
home_away
field
result

Question: Name the opponent when the field is mitchel athletic complex
SQL: SELECT "opponent" FROM game_results_2006 WHERE "field" = 'mitchel athletic complex'

Question: Name the date for when the home/away is away and the opponent is bayhawks
SQL: SELECT "date" FROM game_results_2006 WHERE "home_away" = 'away' AND "opponent" = 'bayhawks'

Question: Say the field with a result of w 12-11
SQL: SELECT "field" FROM game_results_2006 WHERE "result" = 'w 12-11'

Question: Name the opponent when the result is w 16-15 and has home/away of home
SQL: SELECT "opponent" FROM game_results_2006 WHERE "home_away" = 'home' AND "result" = 'w 16-15'

Question: Name the opponent when the resultwas w 12-11
SQL: SELECT "opponent" FROM game_results_2006 WHERE "result" = 'w 12-11'

Question: Name the opponent which has a home/away of home and date of july 27
SQL: SELECT "opponent" FROM game_results_2006 WHERE "home_away" = 'home' AND "date" = 'july 27'