CREATE TABLE table_31988 ("Sixes" CLOB, "Player" CLOB, "Opponent" CLOB, "Venue" CLOB, "Date" CLOB)

Where did Zimbabwe play?
SELECT "Venue" FROM table_31988 WHERE "Opponent" = 'zimbabwe'
SELECT "Venue" FROM "table_31988" WHERE "Opponent" = 'zimbabwe'