CREATE TABLE table_name_8 (water__sqmi_ NUMBER, longitude VARCHAR2, pop__2010_ VARCHAR2, township VARCHAR2)

what is the average water sqmi with a population (2010) more than 47 in the Brenna Township with Longitude less than -97.171507
SELECT AVG(water__sqmi_) FROM table_name_8 WHERE pop__2010_ > 47 AND township = "brenna" AND longitude < -97.171507
SELECT AVG("water__sqmi_") FROM "table_name_8" WHERE "brenna" = "township" AND "longitude" < -97.171507 AND "pop__2010_" > 47