user: Question: What is the average feet that has a Latitude (N) of 35°48′35″, and under 8047m?
Columns: ['Peak', 'metres', 'feet', 'Latitude (N)', 'Longitude (E)', 'Prominence (m)']
Types: ['text', 'real', 'real', 'text', 'text', 'real']
Sample row: ['Gasherbrum I', 8080.0, 26509.0, '35°43′27″', '76°41′48″', 2155.0]
SQL:

assistant: SELECT AVG("feet") FROM "Table" WHERE "Latitude (N)" = '35°48′35″' AND "metres" < 8047.0;