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

Which gold has a Bronze of 1, a Rank of 47, and a Nation of spain?
SELECT "Gold" FROM table_70668 WHERE "Bronze" = '1' AND "Rank" = '47' AND "Nation" = 'spain'
SELECT "Gold" FROM "table_70668" WHERE "Bronze" = '1' AND "Nation" = 'spain' AND "Rank" = '47'