Table: test_matches_1991_2000_2
Columns: date
home_captain
away_captain
venue
result

Question: Who is the home captain that played at Edgbaston?
SQL: SELECT "home_captain" FROM test_matches_1991_2000_2 WHERE "venue" = 'edgbaston'

Question: Who is the home captain that played at Edgbaston?
SQL: SELECT "home_captain" FROM test_matches_1991_2000_2 WHERE "venue" = 'edgbaston'

Question: For the matches with home captain Graham Gooch played on the dates 3,4,5,6,7 June 1993, what was the result?
SQL: SELECT "result" FROM test_matches_1991_2000_2 WHERE "home_captain" = 'graham gooch' AND "date" = '3,4,5,6,7 june 1993'

Question: What was the venue for the matches played on the dates 3,4,5,6,7 June 1993?
SQL: SELECT "venue" FROM test_matches_1991_2000_2 WHERE "date" = '3,4,5,6,7 june 1993'

Question: Who was the away captain for matches played at Trent Bridge?
SQL: SELECT "away_captain" FROM test_matches_1991_2000_2 WHERE "venue" = 'trent bridge'