user: ### NOW ANSWER:
Question: Name the total number of nicknames for St. Bonaventure University
Columns: ['School', 'Location', 'Founded', 'Affiliation', 'Enrollment', 'Nickname', 'Primary conference']
Types: ['text', 'text', 'real', 'text', 'real', 'text', 'text']
Sample row: ['Binghamton University', 'Vestal, NY', 1946.0, 'Public', 14898.0, 'Bearcats', 'America East Conference ( D-I )']
SQL:

assistant: SELECT COUNT("Nickname") FROM "Table" WHERE "School" = 'St. Bonaventure University';