What is the total number of rounds that had draft pick 97, duncan mccoll?
CREATE TABLE table_name_62 (round VARCHAR, player VARCHAR, pick VARCHAR)
SELECT COUNT(round) FROM table_name_62 WHERE player = "duncan mccoll" AND pick < 97
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_62 (round VARCHAR, player VARCHAR, pick VARCHAR) Question: What is the total number of rounds that had draft pick 97, duncan mccoll? [/INST] SELECT COUNT(round) FROM table_name_62 WHERE player = "duncan mccoll" AND pick < 97 </s>