CREATE TABLE table_47889 ("Official Name" TEXT, "Status" TEXT, "Area km 2" FLOAT, "Population" FLOAT, "Census Ranking" TEXT)

What is the average population vlue for an area smaller than 26.69 square km and has an official name of Rogersville?
SELECT AVG("Population") FROM table_47889 WHERE "Area km 2" < '26.69' AND "Official Name" = 'rogersville'
SELECT AVG("Population") FROM "table_47889" WHERE "Area km 2" < '26.69' AND "Official Name" = 'rogersville'