user: ### NOW ANSWER:
Question: Which province has the soccer stadium that holds 4,000 people?
Columns: ['University', 'Varsity Name', 'City', 'Province', 'Founded', 'Soccer Stadium', 'Stadium Capacity']
Types: ['text', 'text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['Acadia University', 'Axemen', 'Wolfville', 'NS', 1838.0, 'Raymond Field', '3,000']
SQL:

assistant: SELECT "Province" FROM "Table" WHERE "Stadium Capacity" = '4,000';