Table: frostburg_state_enrollment
Columns: states
fall_05
fall_06
fall_07
fall_08
fall_09

Question: What number is Fall 08 from the state with 57 in Fall 06 and 74 or less in Fall 05?
SQL: SELECT COUNT("fall_08") FROM frostburg_state_enrollment WHERE "fall_06" = 57 AND "fall_05" < 74

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?
SQL: SELECT AVG("fall_06") FROM frostburg_state_enrollment WHERE "fall_08" < 79 AND "fall_07" > 36 AND "fall_05" > 74

Question: What number is Fall 06 from the state with 34 for Fall 09?
SQL: SELECT AVG("fall_06") FROM frostburg_state_enrollment WHERE "fall_09" = 34