Table: bridgeport_barrage_2001_games
Columns: date
opponent
home_away
field
result

Question: What is the result when you play at home against Pride
SQL: SELECT "result" FROM bridgeport_barrage_2001_games WHERE "home_away" = 'home' AND "opponent" = 'pride'

Question: What is the result of games played at frontier field
SQL: SELECT "result" FROM bridgeport_barrage_2001_games WHERE "field" = 'frontier field'

Question: What days were games played at Hofstra Stadium?
SQL: SELECT "date" FROM bridgeport_barrage_2001_games WHERE "field" = 'hofstra stadium'

Question: What Field was played at in an away game against the bayhawks?
SQL: SELECT "field" FROM bridgeport_barrage_2001_games WHERE "home_away" = 'away' AND "opponent" = 'bayhawks'