how many pick# does the chivas usa  mls team have
CREATE TABLE table_29626583_1 (pick__number INTEGER, mls_team VARCHAR)
SELECT MAX(pick__number) FROM table_29626583_1 WHERE mls_team = "Chivas USA"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_29626583_1 (pick__number INTEGER, mls_team VARCHAR) Question: how many pick# does the chivas usa  mls team have [/INST] SELECT MAX(pick__number) FROM table_29626583_1 WHERE mls_team = "Chivas USA" </s>