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