What is the Brigade, when the Type is Rural, and when the value for Tankers is 1?
CREATE TABLE table_name_10 (brigade VARCHAR, type VARCHAR, tankers VARCHAR)
SELECT brigade FROM table_name_10 WHERE type = "rural" AND tankers = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_10 (brigade VARCHAR, type VARCHAR, tankers VARCHAR) Question: What is the Brigade, when the Type is Rural, and when the value for Tankers is 1? [/INST] SELECT brigade FROM table_name_10 WHERE type = "rural" AND tankers = 1 </s>