What was the result in the Tennessee 6 district election?
CREATE TABLE table_1342270_42 (result VARCHAR, district VARCHAR)
SELECT result FROM table_1342270_42 WHERE district = "Tennessee 6"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1342270_42 (result VARCHAR, district VARCHAR) Question: What was the result in the Tennessee 6 district election? [/INST] SELECT result FROM table_1342270_42 WHERE district = "Tennessee 6" </s>