Which tournament had A in 2008, and a 1r in 2010?
CREATE TABLE table_name_4 (tournament VARCHAR)
SELECT tournament FROM table_name_4 WHERE 2008 = "a" AND 2010 = "1r"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (tournament VARCHAR) Question: Which tournament had A in 2008, and a 1r in 2010? [/INST] SELECT tournament FROM table_name_4 WHERE 2008 = "a" AND 2010 = "1r" </s>