CREATE TABLE table_name_8 (engine VARCHAR, year VARCHAR, power VARCHAR)

Which Engine has a Year that's Larger than 2006 and Power of BHP (KW)?
SELECT engine FROM table_name_8 WHERE year > 2006 AND power = "bhp (kw)"
SELECT "engine" FROM "table_name_8" WHERE "bhp (kw)" = "power" AND "year" > 2006