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

What is the largest gold when silver is less than 1 for Canada and bronze is less than 0?
SELECT MAX("Gold") FROM table_57397 WHERE "Silver" < '1' AND "Nation" = 'canada' AND "Bronze" < '0'
SELECT MAX("Gold") FROM "table_57397" WHERE "Bronze" < '0' AND "Nation" = 'canada' AND "Silver" < '1'