CREATE TABLE table_name_97 (player VARCHAR2, pick__number VARCHAR2, mls_team VARCHAR2)

Tell me the player for pick number less than 29 and mls team of chicago fire
SELECT player FROM table_name_97 WHERE pick__number < 29 AND mls_team = "chicago fire"
SELECT "player" FROM "table_name_97" WHERE "chicago fire" = "mls_team" AND "pick__number" < 29