Which province has the soccer stadium that holds 4,000 people?
CREATE TABLE table_27369069_1 (province VARCHAR, stadium_capacity VARCHAR)
SELECT province FROM table_27369069_1 WHERE stadium_capacity = "4,000"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_27369069_1 (province VARCHAR, stadium_capacity VARCHAR) Question: Which province has the soccer stadium that holds 4,000 people? [/INST] SELECT province FROM table_27369069_1 WHERE stadium_capacity = "4,000" </s>