Table: cricket_stats_2007
Columns: sixes
player
opponent
venue
date

Question: Where did Zimbabwe play?
SQL: SELECT "venue" FROM cricket_stats_2007 WHERE "opponent" = 'zimbabwe'

Question: What is the date when Canada played?
SQL: SELECT "date" FROM cricket_stats_2007 WHERE "opponent" = 'canada'