Table: midwest_lacrosse_teams
Columns: institution
city
state
team_name
affiliation
enrollment
home_conference

Question: How many institutes have the team name Spartans?
SQL: SELECT COUNT("institution") FROM midwest_lacrosse_teams WHERE "team_name" = 'Spartans'

Question: How many states were there when there was an enrollment of 2789?
SQL: SELECT COUNT("state") FROM midwest_lacrosse_teams WHERE "enrollment" = 2789

Question: What kind of institute is in Indiana?
SQL: SELECT "affiliation" FROM midwest_lacrosse_teams WHERE "state" = 'Indiana'

Question: How many people enrolled for the institute with the Pioneers?
SQL: SELECT MIN("enrollment") FROM midwest_lacrosse_teams WHERE "team_name" = 'Pioneers'

Question: What team is in the city of Rock Island?
SQL: SELECT "team_name" FROM midwest_lacrosse_teams WHERE "city" = 'Rock Island'