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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (overall VARCHAR, name VARCHAR) Question: What is John Cole's overall pick number? [/INST] SELECT COUNT(overall) FROM table_name_47 WHERE name = "john cole" </s>