user: ### NOW ANSWER:
Question: How many opponents were in North Carolina State game?
Columns: ['Game', 'Date', 'Opponent', 'Result', 'Cardinals points', 'Opponents', 'Record']
Types: ['real', 'text', 'text', 'text', 'real', 'real', 'text']
Sample row: [1.0, 'Sept. 29', '@ Wayne State', 'Win', 28.0, 12.0, '1-0']
SQL:

assistant: SELECT COUNT("Opponents") FROM "Table" WHERE "Opponent" = 'North Carolina State';