Table: game_results_2008_2
Columns: date
opponent
home_away
field
result

Question: What field is an opponent of cannons and resulted with w 16-11?
SQL: SELECT "field" FROM game_results_2008_2 WHERE "opponent" = 'cannons' AND "result" = 'w 16-11'

Question: what is the result from texas stadium?
SQL: SELECT "result" FROM game_results_2008_2 WHERE "field" = 'texas stadium'

Question: What field resulted with w 18-12?
SQL: SELECT "field" FROM game_results_2008_2 WHERE "result" = 'w 18-12'

Question: What field had results of w 18-12?
SQL: SELECT "field" FROM game_results_2008_2 WHERE "result" = 'w 18-12'