Which Engine has a Year that's Larger than 2006 and Power of BHP (KW)?
CREATE TABLE table_name_8 (engine VARCHAR, year VARCHAR, power VARCHAR)
SELECT engine FROM table_name_8 WHERE year > 2006 AND power = "bhp (kw)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (engine VARCHAR, year VARCHAR, power VARCHAR) Question: Which Engine has a Year that's Larger than 2006 and Power of BHP (KW)? [/INST] SELECT engine FROM table_name_8 WHERE year > 2006 AND power = "bhp (kw)" </s>