CREATE TABLE table_204_617 (id NUMBER, "date" CLOB, "opponent#" CLOB, "rank#" CLOB, "site" CLOB, "tv" CLOB, "result" CLOB, "attendance" NUMBER)

how many consecutive times was the rank # 2 ?
SELECT COUNT(*) FROM table_204_617 WHERE "rank#" = 2
SELECT COUNT(*) FROM "table_204_617" WHERE "rank#" = 2