CREATE TABLE table_name_11 (feet INT, latitude__n_ VARCHAR, metres VARCHAR)

What is the average feet that has a Latitude (N) of 35 48 35 , and under 8,047m?
SELECT AVG(feet) FROM table_name_11 WHERE latitude__n_ = "35°48′35″" AND metres < 8 OFFSET 047
SELECT AVG("feet") FROM "table_name_11" WHERE "35°48′35″" = "latitude__n_" AND "metres" < 8 OFFSET 047