user: Question: How many schools are in Bloomington, IN?
Columns: ['School', 'Location', 'Founded', 'Affiliation', 'Enrollment', 'Team Nickname', 'Primary conference']
Types: ['text', 'text', 'real', 'text', 'real', 'text', 'text']
Sample row: ['Indiana University', 'Bloomington, IN', 1820.0, 'Public', 40354.0, 'Hoosiers', 'Big Ten Conference ( D-I )']
SQL:

assistant: SELECT COUNT("Founded") FROM "Table" WHERE "Location" = 'Bloomington, IN';