Table schema:
CREATE TABLE table_name_47 (overall VARCHAR, name VARCHAR)

Question: What is John Cole's overall pick number?
SQL: SELECT COUNT(overall) FROM table_name_47 WHERE name = "john cole"