CREATE TABLE table_31917 ("Pick #" FLOAT, "MLS team" CLOB, "Player" CLOB, "Position" CLOB, "Affiliation" CLOB)

Chicago fire has a total of a total of how many #s?
SELECT COUNT("Pick #") FROM table_31917 WHERE "MLS team" = 'chicago fire'
SELECT COUNT("Pick #") FROM "table_31917" WHERE "MLS team" = 'chicago fire'