Name the chassis for 1970 and tyres of d
CREATE TABLE table_name_12 (chassis VARCHAR, tyres VARCHAR, year VARCHAR)
SELECT chassis FROM table_name_12 WHERE tyres = "d" AND year = 1970
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (chassis VARCHAR, tyres VARCHAR, year VARCHAR) Question: Name the chassis for 1970 and tyres of d [/INST] SELECT chassis FROM table_name_12 WHERE tyres = "d" AND year = 1970 </s>