Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_92 ( fall_06 INTEGER, fall_05 VARCHAR, fall_08 VARCHAR, fall_07 VARCHAR )

### Question ###
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?

### Accurate SQL ###

SELECT AVG(fall_06) FROM table_name_92 WHERE fall_08 < 79 AND fall_07 > 36 AND fall_05 > 74