user: ### NOW ANSWER:
Question: What is the population in 2011 for the name Beaubassin East?
Columns: ['Name', 'Population (2011)', 'Population (2006)', 'Change (%)', 'Area (km²)', 'Population density']
Types: ['text', 'real', 'real', 'text', 'text', 'text']
Sample row: ['Beaubassin East', 6200.0, 6429.0, '-3.6', '291.12', '21.3']
SQL:

assistant: SELECT "Population (2011)" FROM "Table" WHERE "Name" = 'Beaubassin East';