Table: game_results_2005
Columns: date
opponent
home_away
field
result

Question: Is it home or away when opponent is Pride with a W 11-10 result?
SQL: SELECT "home_away" FROM game_results_2005 WHERE "opponent" = 'pride' AND "result" = 'w 11-10'

Question: Who is the opponent at Bishop Kearney Field?
SQL: SELECT "opponent" FROM game_results_2005 WHERE "field" = 'bishop kearney field'

Question: On what date were the opponents the Bayhawks at a home game?
SQL: SELECT "date" FROM game_results_2005 WHERE "home_away" = 'home' AND "opponent" = 'bayhawks'