Table: conference_institutions
Columns: institution
location
founded
type
enrollment
nickname
joined
division

Question: How many teams have skyhawks as a nickname?
SQL: SELECT COUNT("division") FROM conference_institutions WHERE "nickname" = 'Skyhawks'

Question: What is the total enrollment for the school in garden city, new york?
SQL: SELECT "enrollment" FROM conference_institutions WHERE "location" = 'Garden City, New York'

Question: How many schools with greyhounds as their nickname?
SQL: SELECT COUNT("institution") FROM conference_institutions WHERE "nickname" = 'Greyhounds'

Question: How many schools named southern new hampshire university?
SQL: SELECT COUNT("enrollment") FROM conference_institutions WHERE "institution" = 'Southern New Hampshire University'