What was the 2006 population count of the local government area where Coober Pedy is located?
CREATE TABLE table_23685890_2 (
    pop_2006 VARCHAR,
    major_town VARCHAR
)
SELECT pop_2006 FROM table_23685890_2 WHERE major_town = "Coober Pedy"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What was the 2006 population count of the local government area where Coober Pedy is located? ### Input: CREATE TABLE table_23685890_2 (
    pop_2006 VARCHAR,
    major_town VARCHAR
) ### Response: SELECT pop_2006 FROM table_23685890_2 WHERE major_town = "Coober Pedy"