You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_12834315_8 (barrel_length VARCHAR, rear_sight VARCHAR, barrel_profile VARCHAR)
system
How many inches is the barrel length when the rear sight is weaver and the barrel profile is A2?
user
SELECT barrel_length FROM table_12834315_8 WHERE rear_sight = "Weaver" AND barrel_profile = "A2"
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_12834315_8 (barrel_length VARCHAR, rear_sight VARCHAR, barrel_profile VARCHAR)<|im_end|>
<|im_start|>user
How many inches is the barrel length when the rear sight is weaver and the barrel profile is A2?<|im_end|>
