Table: conference_schools_4
Columns: institution
location
nickname
current_conference
classification

Question: Where is NCAA division ii Franklin Pierce University located at?
SQL: SELECT "location" FROM conference_schools_4 WHERE "classification" = 'ncaa division ii' AND "institution" = 'franklin pierce university'

Question: Post University has what nickname?
SQL: SELECT "nickname" FROM conference_schools_4 WHERE "institution" = 'post university'

Question: The River Hawks belonged to what current conference?
SQL: SELECT "current_conference" FROM conference_schools_4 WHERE "nickname" = 'river hawks'

Question: What is the nickname of the school located in Manchester, New Hampshire?
SQL: SELECT "nickname" FROM conference_schools_4 WHERE "location" = 'manchester, new hampshire'

Question: What is the classification for the school in the NEC Conference located in New Britain, Connecticut?
SQL: SELECT "classification" FROM conference_schools_4 WHERE "current_conference" = 'nec' AND "location" = 'new britain, connecticut'

Question: What institution is a NCAA Division i school and part of the NEC conference with a nickname the Blue Devils?
SQL: SELECT "institution" FROM conference_schools_4 WHERE "classification" = 'ncaa division i' AND "current_conference" = 'nec' AND "nickname" = 'blue devils'