What is the muzzle device with a 1:7 barrel twist and a stock 4th generation?
CREATE TABLE table_name_47 (muzzle_device VARCHAR, barrel_twist VARCHAR, stock VARCHAR)
SELECT muzzle_device FROM table_name_47 WHERE barrel_twist = "1:7" AND stock = "4th generation"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (muzzle_device VARCHAR, barrel_twist VARCHAR, stock VARCHAR) Question: What is the muzzle device with a 1:7 barrel twist and a stock 4th generation? [/INST] SELECT muzzle_device FROM table_name_47 WHERE barrel_twist = "1:7" AND stock = "4th generation" </s>