human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Round, Pick, Player, Position, School/Club Team
###Question: What is the total number of rounds that had draft pick 97, duncan mccoll?
gpt
SELECT COUNT Round FROM table WHERE Player = duncan mccoll AND Pick < 97