Which Yards has a Attempts of 247
CREATE TABLE table_name_74 (yards VARCHAR, attempts VARCHAR)
SELECT yards FROM table_name_74 WHERE attempts = "247"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (yards VARCHAR, attempts VARCHAR) Question: Which Yards has a Attempts of 247 [/INST] SELECT yards FROM table_name_74 WHERE attempts = "247" </s>