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

Which Gold has a Bronze of 1, and a Total smaller than 3?
SELECT AVG("Gold") FROM table_47697 WHERE "Bronze" = '1' AND "Total" < '3'
SELECT AVG("Gold") FROM "table_47697" WHERE "Bronze" = '1' AND "Total" < '3'