Which constructor has 10-12 rounds and a M7A chassis?
CREATE TABLE table_name_40 (constructor VARCHAR, rounds VARCHAR, chassis VARCHAR)
SELECT constructor FROM table_name_40 WHERE rounds = "10-12" AND chassis = "m7a"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (constructor VARCHAR, rounds VARCHAR, chassis VARCHAR) Question: Which constructor has 10-12 rounds and a M7A chassis? [/INST] SELECT constructor FROM table_name_40 WHERE rounds = "10-12" AND chassis = "m7a" </s>