Table: test_matches_1991_2000
Columns: date
home_captain
away_captain
venue
result

Question: When has a Venue of Adelaide Oval?
SQL: SELECT "date" FROM test_matches_1991_2000 WHERE "venue" = 'adelaide oval'

Question: What is the Home Captain which has Waca Ground as a Venue
SQL: SELECT "home_captain" FROM test_matches_1991_2000 WHERE "venue" = 'waca ground'