What is Player, when Country is "United States", and when Year(s) Won is "1976"?
CREATE TABLE table_name_40 (player VARCHAR, country VARCHAR, year_s__won VARCHAR)
SELECT player FROM table_name_40 WHERE country = "united states" AND year_s__won = "1976"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (player VARCHAR, country VARCHAR, year_s__won VARCHAR) Question: What is Player, when Country is "United States", and when Year(s) Won is "1976"? [/INST] SELECT player FROM table_name_40 WHERE country = "united states" AND year_s__won = "1976" </s>