question: Who is the Constructor for driver Piercarlo Ghinzani and a Ford cosworth dfv 3.0 v8 engine?
answer: SELECT constructor FROM table_name_42 WHERE driver = "piercarlo ghinzani" AND engine = "ford cosworth dfv 3.0 v8"
context: CREATE TABLE table_name_42 (constructor VARCHAR, driver VARCHAR, engine VARCHAR)