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

how many many competitions were held in 2006 ?
SELECT COUNT("competition") FROM table_204_98 WHERE "year" = 2006
SELECT COUNT("competition") FROM "table_204_98" WHERE "year" = 2006