What is the pick number for the kansas city royals?
CREATE TABLE table_name_12 (pick INTEGER, team VARCHAR)
SELECT SUM(pick) FROM table_name_12 WHERE team = "kansas city royals"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (pick INTEGER, team VARCHAR) Question: What is the pick number for the kansas city royals? [/INST] SELECT SUM(pick) FROM table_name_12 WHERE team = "kansas city royals" </s>