user: ### NOW ANSWER:
Question: What was the 2006 population count of the local government area where Coober Pedy is located?
Columns: ['Local Government Area', 'Type', 'Major Town', 'Land Area (km²)', 'Pop. 2006', 'Density km −2', 'Towns', 'Est.']
Types: ['text', 'text', 'text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['Roxby Downs', 'Municipal Council', 'Roxby Downs', '110', 4292.0, 39018.0, 2.0, 1982.0]
SQL:

assistant: SELECT "Pop. 2006" FROM "Table" WHERE "Major Town" = 'Coober Pedy';