CREATE TABLE table_203_462 (id NUMBER, "year" NUMBER, "division" NUMBER, "league" CLOB, "regular season" CLOB, "playoffs" CLOB, "open cup" CLOB)

how many years did not qualify ?
SELECT COUNT("year") FROM table_203_462 WHERE "playoffs" = 'did not qualify'
SELECT COUNT("year") FROM "table_203_462" WHERE "playoffs" = 'did not qualify'