user: ### NOW ANSWER:
Question: what is the number of opponents where the location is Syracuse, NY?
Columns: ['Date', 'Opponent', 'Location', 'Irish Points', 'Opp. Points', 'Record']
Types: ['text', 'text', 'text', 'real', 'real', 'text']
Sample row: ['Nov. 15/08', 'Central Connecticut', 'Tampa, FL', 100.0, 41.0, '1-0']
SQL:

assistant: SELECT COUNT("Opponent") FROM "Table" WHERE "Location" = 'Syracuse, NY';