user: ### NOW ANSWER:
Question: What is the location when the opposition is Mid Canterbury?
Columns: ['Round #', 'Home Team', 'Win/Loss', 'Score', 'Opposition', 'Location']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Round 1', 'Wanganui', 'Win', '46 - 6', 'East Coast', 'Wanganui']
SQL:

assistant: SELECT "Location" FROM "Table" WHERE "Opposition" = 'Mid Canterbury';