What nation scored 7 in shooting in 1920?
CREATE TABLE table_name_39 (nation VARCHAR, years VARCHAR, sport VARCHAR, total VARCHAR)
SELECT nation FROM table_name_39 WHERE sport = "shooting" AND total = 7 AND years = "1920"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_39 (nation VARCHAR, years VARCHAR, sport VARCHAR, total VARCHAR) Question: What nation scored 7 in shooting in 1920? [/INST] SELECT nation FROM table_name_39 WHERE sport = "shooting" AND total = 7 AND years = "1920" </s>