What's the sum of the Pick that has the Player of Robert Ingalls?
CREATE TABLE table_name_47 (pick VARCHAR, player VARCHAR)
SELECT COUNT(pick) FROM table_name_47 WHERE player = "robert ingalls"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (pick VARCHAR, player VARCHAR) Question: What's the sum of the Pick that has the Player of Robert Ingalls? [/INST] SELECT COUNT(pick) FROM table_name_47 WHERE player = "robert ingalls" </s>