CREATE TABLE table_name_62 (round VARCHAR2, player VARCHAR2, pick VARCHAR2)

What is the total number of rounds that had draft pick 97, duncan mccoll?
SELECT COUNT(round) FROM table_name_62 WHERE player = "duncan mccoll" AND pick < 97
SELECT COUNT("round") FROM "table_name_62" WHERE "duncan mccoll" = "player" AND "pick" < 97