Which Hand guards has a Barrel profile of a2 and a Rear sight of weaver?
CREATE TABLE table_name_1 (hand_guards VARCHAR, barrel_profile VARCHAR, rear_sight VARCHAR)
SELECT hand_guards FROM table_name_1 WHERE barrel_profile = "a2" AND rear_sight = "weaver"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (hand_guards VARCHAR, barrel_profile VARCHAR, rear_sight VARCHAR) Question: Which Hand guards has a Barrel profile of a2 and a Rear sight of weaver? [/INST] SELECT hand_guards FROM table_name_1 WHERE barrel_profile = "a2" AND rear_sight = "weaver" </s>