Table: frostburg_state_university_enrollment
Columns: maryland_counties
fall_05
fall_06
fall_07
fall_08
fall_09

Question: What is the average value for Fall 07 when Fall 05 is 271 and Fall 09 is less than 347?
SQL: SELECT AVG("fall_07") FROM frostburg_state_university_enrollment WHERE "fall_05" = 271 AND "fall_09" < 347

Question: What was the average value for Fall 07 when Fall 09 is less than 296?
SQL: SELECT AVG("fall_07") FROM frostburg_state_university_enrollment WHERE "fall_09" < 296

Question: What is the sum of all values in Fall 09 in Allegany county with Fall 07 less than 751?
SQL: SELECT SUM("fall_09") FROM frostburg_state_university_enrollment WHERE "maryland_counties" = 'allegany' AND "fall_07" < 751

Question: What is the largest value for Fall 08 when Fall 09 is 792 and Fall 05 is less than 791?
SQL: SELECT MAX("fall_08") FROM frostburg_state_university_enrollment WHERE "fall_09" = 792 AND "fall_05" < 791

Question: What is the largest value for Fall 08 when Fall 07 is less than 242?
SQL: SELECT MAX("fall_08") FROM frostburg_state_university_enrollment WHERE "fall_07" < 242