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

Who ha the gold and 1 bronze, and more than 0 silver?
SELECT "Gold" FROM table_38991 WHERE "Bronze" = '1' AND "Silver" > '0'
SELECT "Gold" FROM "table_38991" WHERE "Bronze" = '1' AND "Silver" > '0'