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

How many gold have a silver of 1 and a bronze of 0?
SELECT SUM("Gold") FROM table_42147 WHERE "Silver" = '1' AND "Bronze" < '1'
SELECT SUM("Gold") FROM "table_42147" WHERE "Bronze" < '1' AND "Silver" = '1'