CREATE TABLE table_name_92 (fall_06 NUMBER, fall_05 VARCHAR2, fall_08 VARCHAR2, fall_07 VARCHAR2)

What number is Fall 06 from the state with 79 or less in Fall 08, 36 or greater in Fall 07 and greater than 74 in Fall 05?
SELECT AVG(fall_06) FROM table_name_92 WHERE fall_08 < 79 AND fall_07 > 36 AND fall_05 > 74
SELECT AVG("fall_06") FROM "table_name_92" WHERE "fall_05" > 74 AND "fall_07" > 36 AND "fall_08" < 79