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

what is the difference between the number of medals earned by the highest earning country and the lowest earning country ?
SELECT MAX("total") - MIN("total") FROM table_204_297
SELECT MAX("total") - MIN("total") FROM "table_204_297"