CREATE TABLE table_name_74 (player VARCHAR, long VARCHAR, yards VARCHAR)

Which Player had a Long of 5 and Yards of 6?
SELECT player FROM table_name_74 WHERE long = "5" AND yards = "6"
SELECT "player" FROM "table_name_74" WHERE "5" = "long" AND "6" = "yards"