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

what is the total number of medals for all the countries ranked fourth ?
SELECT SUM("total") FROM table_204_308 WHERE "rank" = 4
SELECT SUM("total") FROM "table_204_308" WHERE "rank" = 4