CREATE TABLE table_204_920 (id NUMBER, "goal" NUMBER, "date" CLOB, "location" CLOB, "opponent" CLOB, "lineup" CLOB, "min" NUMBER, "assist/pass" CLOB, "score" CLOB, "result" CLOB, "competition" CLOB)

how many total goals were scored against nigeria ?
SELECT COUNT("goal") FROM table_204_920 WHERE "opponent" = 'nigeria'
SELECT COUNT("goal") FROM "table_204_920" WHERE "opponent" = 'nigeria'