user: ### NOW ANSWER:
Question: What is the Population of the Rural community
Columns: ['Official Name', 'Status', 'Area km 2', 'Population', 'Census Ranking']
Types: ['text', 'text', 'real', 'real', 'text']
Sample row: ['Fredericton', 'City', 130.68, 56224.0, '90 of 5,008']
SQL:

assistant: SELECT "Population" FROM "Table" WHERE "Status" = 'Rural community';