How many members arrived on the main island in week 4?
CREATE TABLE table_11764007_2 (member VARCHAR, week_arrived_on_main_island VARCHAR)
SELECT COUNT(member) FROM table_11764007_2 WHERE week_arrived_on_main_island = "4"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11764007_2 (member VARCHAR, week_arrived_on_main_island VARCHAR) Question: How many members arrived on the main island in week 4? [/INST] SELECT COUNT(member) FROM table_11764007_2 WHERE week_arrived_on_main_island = "4" </s>