What shows for miles [One Way] when the fans took 340?
CREATE TABLE table_name_89 (one_way VARCHAR, miles_ INTEGER, fans_took VARCHAR)
SELECT AVG(miles_) AS "one_way" FROM table_name_89 WHERE fans_took = "340"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_89 (one_way VARCHAR, miles_ INTEGER, fans_took VARCHAR) Question: What shows for miles [One Way] when the fans took 340? [/INST] SELECT AVG(miles_) AS "one_way" FROM table_name_89 WHERE fans_took = "340" </s>