CREATE TABLE table_204_974 (id NUMBER, "season" NUMBER, "level" CLOB, "division" CLOB, "section" CLOB, "administration" CLOB, "position" CLOB, "movements" CLOB)

how many consecutive times did they play in tier 4 ?
SELECT COUNT(*) FROM table_204_974 WHERE "level" = 'tier 4'
SELECT COUNT(*) FROM "table_204_974" WHERE "level" = 'tier 4'