CREATE TABLE table_name_2 (chassis VARCHAR2, year VARCHAR2, engine VARCHAR2)

What chassis is used in 1989 with a cosworth engine?
SELECT chassis FROM table_name_2 WHERE year = 1989 AND engine = "cosworth"
SELECT "chassis" FROM "table_name_2" WHERE "cosworth" = "engine" AND "year" = 1989