CREATE TABLE table_204_880 (id NUMBER, "year" NUMBER, "competition" CLOB, "venue" CLOB, "position" CLOB, "event" CLOB, "notes" CLOB)

how many years are listed above 2007 ?
SELECT COUNT("year") FROM table_204_880 WHERE id < (SELECT id FROM table_204_880 WHERE "year" = 2007)
SELECT COUNT("year") FROM "table_204_880" WHERE "id" < (SELECT "id" FROM "table_204_880" WHERE "year" = 2007)