Table: bridgeport_2003_games
Columns: date
opponent
home_away
field
result

Question: Who is the opponent on June 6?
SQL: SELECT "opponent" FROM bridgeport_2003_games WHERE "date" = 'june 6'

Question: What is the date of the game at Commerce Bank Ballpark?
SQL: SELECT "date" FROM bridgeport_2003_games WHERE "field" = 'commerce bank ballpark'

Question: What is the result of the game at Bishop Kearney Field on August 2?
SQL: SELECT "result" FROM bridgeport_2003_games WHERE "field" = 'bishop kearney field' AND "date" = 'august 2'

Question: Who was the opponent of the game at Homewood field?
SQL: SELECT "opponent" FROM bridgeport_2003_games WHERE "field" = 'homewood field'

Question: What is the result of the game at Bishop Kearney Field on August 2?
SQL: SELECT "result" FROM bridgeport_2003_games WHERE "field" = 'bishop kearney field' AND "date" = 'august 2'