CREATE TABLE table_51228 ("Player" CLOB, "Car." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "TD's" FLOAT, "Long" FLOAT)

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