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

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"