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

How many yards have a Player of james macpherson, and a Long smaller than 1?
SELECT COUNT(yards) FROM table_name_6 WHERE player = "james macpherson" AND long < 1
SELECT COUNT("yards") FROM "table_name_6" WHERE "james macpherson" = "player" AND "long" < 1