user: ### NOW ANSWER:
Question: What is the average population vlue for an area smaller than 26.69 square km and has an official name of Rogersville?
Columns: ['Official Name', 'Status', 'Area km 2', 'Population', 'Census Ranking']
Types: ['text', 'text', 'real', 'real', 'text']
Sample row: ['Miramichi', 'City', 179.84, 17811.0, '232 of 5,008']
SQL:

assistant: SELECT AVG("Population") FROM "Table" WHERE "Area km 2" < 26.69 AND "Official Name" = 'Rogersville';