What Year has a Tyre of D, and Chassis of Mazda 787?
CREATE TABLE table_name_55 (year VARCHAR, tyre VARCHAR, chassis VARCHAR)
SELECT year FROM table_name_55 WHERE tyre = "d" AND chassis = "mazda 787"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (year VARCHAR, tyre VARCHAR, chassis VARCHAR) Question: What Year has a Tyre of D, and Chassis of Mazda 787? [/INST] SELECT year FROM table_name_55 WHERE tyre = "d" AND chassis = "mazda 787" </s>