user: ### NOW ANSWER:
Question: What is the average evening gown score of the contestant from new york with a swimsuit score less than 8.703 and preliminaries larger than 8.292?
Columns: ['State', 'Preliminaries', 'Interview', 'Swimsuit', 'Evening Gown', 'Average']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Mississippi', 8.852, 9.123, 9.366, 9.343, 9.277]
SQL:

assistant: SELECT AVG("Evening Gown") FROM "Table" WHERE "Swimsuit" < 8.703 AND "State" = 'new york' AND "Preliminaries" > 8.292;