CREATE TABLE table_58873 ("Rank" FLOAT, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

How many totals have a Gold larger than 0, and a Bronze smaller than 0?
SELECT COUNT("Total") FROM table_58873 WHERE "Gold" > '0' AND "Bronze" < '0'
SELECT COUNT("Total") FROM "table_58873" WHERE "Bronze" < '0' AND "Gold" > '0'