What is the average feet that has a Latitude (N) of 35°48′35″, and under 8,047m?
CREATE TABLE table_name_11 (feet INTEGER, latitude__n_ VARCHAR, metres VARCHAR)
SELECT AVG(feet) FROM table_name_11 WHERE latitude__n_ = "35°48′35″" AND metres < 8 OFFSET 047 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_11 (feet INTEGER, latitude__n_ VARCHAR, metres VARCHAR) Question: What is the average feet that has a Latitude (N) of 35°48′35″, and under 8,047m? [/INST] SELECT AVG(feet) FROM table_name_11 WHERE latitude__n_ = "35°48′35″" AND metres < 8 OFFSET 047 ROWS </s>