CREATE TABLE table_204_9 (id NUMBER, "week" NUMBER, "date" CLOB, "opponent" CLOB, "result" CLOB, "attendance" NUMBER)

what is the total number of opponent ?
SELECT COUNT("opponent") FROM table_204_9
SELECT COUNT("opponent") FROM "table_204_9"