What is John Cole's overall pick number?
CREATE TABLE table_name_47 (
    overall VARCHAR,
    name VARCHAR
)
SELECT COUNT(overall) FROM table_name_47 WHERE name = "john cole"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is John Cole's overall pick number? ### Input: CREATE TABLE table_name_47 (
    overall VARCHAR,
    name VARCHAR
) ### Response: SELECT COUNT(overall) FROM table_name_47 WHERE name = "john cole"