user: ### NOW ANSWER:
Question: What is the total number of rounds that had draft pick 97, duncan mccoll?
Columns: ['Round', 'Pick', 'Player', 'Position', 'School/Club Team']
Types: ['real', 'real', 'text', 'text', 'text']
Sample row: [4.0, 97.0, 'Duncan McColl', 'Defensive End', 'Stanford']
SQL:

assistant: SELECT COUNT("Round") FROM "Table" WHERE "Player" = 'duncan mccoll' AND "Pick" < 97.0;