CREATE TABLE table_203_812 (id NUMBER, "rank" NUMBER, "nation" CLOB, "gold" NUMBER, "silver" NUMBER, "bronze" NUMBER, "total" NUMBER)

how many combined gold medals did japan and france win ?
SELECT SUM("gold") FROM table_203_812 WHERE "nation" IN ('japan', 'france')
SELECT SUM("gold") FROM "table_203_812" WHERE "nation" IN ('japan', 'france')