CREATE TABLE table_204_371 (id NUMBER, "team" CLOB, "competition" CLOB, "category" CLOB, "appearances\ start" NUMBER, "appearances\ sub" NUMBER, "goals" NUMBER, "team record" CLOB)

where did japan only score four goals ?
SELECT "competition" FROM table_204_371 WHERE "team" = 'japan' AND "goals" = 4
SELECT "competition" FROM "table_204_371" WHERE "goals" = 4 AND "team" = 'japan'