Which province has the soccer stadium that holds 4,000 people?
create table table_27369069_1 (province varchar, stadium_capacity varchar, PRIMARY KEY (province))
select province from table_27369069_1 where stadium_capacity = "4,000"