Which gold has a Bronze of 1, a Rank of 47, and a Nation of spain?
CREATE TABLE table_name_65 (gold VARCHAR, nation VARCHAR, bronze VARCHAR, rank VARCHAR)
SELECT gold FROM table_name_65 WHERE bronze = "1" AND rank = "47" AND nation = "spain"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_65 (gold VARCHAR, nation VARCHAR, bronze VARCHAR, rank VARCHAR) Question: Which gold has a Bronze of 1, a Rank of 47, and a Nation of spain? [/INST] SELECT gold FROM table_name_65 WHERE bronze = "1" AND rank = "47" AND nation = "spain" </s>