user: Question: Which gold has a Bronze of 1, a Rank of 47, and a Nation of Spain?
Columns: ['Rank', 'Nation', 'Gold', 'Silver', 'Bronze', 'Total']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Russia', '42', '29', '29', '100']
SQL:

assistant: SELECT "Gold" FROM "Table" WHERE "Bronze" = '1' AND "Rank" = '47' AND "Nation" = 'Spain';