Which 2007 has a 2006 of A, and a Tournament of canada?
CREATE TABLE table_name_8 (tournament VARCHAR)
SELECT 2007 FROM table_name_8 WHERE 2006 = "a" AND tournament = "canada"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (tournament VARCHAR) Question: Which 2007 has a 2006 of A, and a Tournament of canada? [/INST] SELECT 2007 FROM table_name_8 WHERE 2006 = "a" AND tournament = "canada" </s>