CREATE TABLE table_name_74 (yards VARCHAR, attempts VARCHAR)

Which Yards has a Attempts of 247
SELECT yards FROM table_name_74 WHERE attempts = "247"
SELECT "yards" FROM "table_name_74" WHERE "247" = "attempts"