CREATE TABLE table_name_47 (overall VARCHAR2, name VARCHAR2)

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