How many picks had less than 11 rounds and a player of Charley Casey?
CREATE TABLE table_name_29 (pick INTEGER, round VARCHAR, player VARCHAR)
SELECT SUM(pick) FROM table_name_29 WHERE round < 11 AND player = "charley casey"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (pick INTEGER, round VARCHAR, player VARCHAR) Question: How many picks had less than 11 rounds and a player of Charley Casey? [/INST] SELECT SUM(pick) FROM table_name_29 WHERE round < 11 AND player = "charley casey" </s>