CREATE TABLE table_name_47 (evening_gown NUMBER, preliminaries VARCHAR2, swimsuit VARCHAR2, state VARCHAR2)

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?
SELECT AVG(evening_gown) FROM table_name_47 WHERE swimsuit < 8.703 AND state = "new york" AND preliminaries > 8.292
SELECT AVG("evening_gown") FROM "table_name_47" WHERE "new york" = "state" AND "preliminaries" > 8.292 AND "swimsuit" < 8.703