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

how many more golds did russia have than germany ?
SELECT (SELECT "gold" FROM table_204_308 WHERE "nation" = 'russia') - (SELECT "gold" FROM table_204_308 WHERE "nation" = 'germany')
SELECT (SELECT "gold" FROM "table_204_308" WHERE "nation" = 'russia') - (SELECT "gold" FROM "table_204_308" WHERE "nation" = 'germany')