Tell me the player for pick number less than 29 and mls team of chicago fire
CREATE TABLE table_name_97 (player VARCHAR, pick__number VARCHAR, mls_team VARCHAR)
SELECT player FROM table_name_97 WHERE pick__number < 29 AND mls_team = "chicago fire"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (player VARCHAR, pick__number VARCHAR, mls_team VARCHAR) Question: Tell me the player for pick number less than 29 and mls team of chicago fire [/INST] SELECT player FROM table_name_97 WHERE pick__number < 29 AND mls_team = "chicago fire" </s>