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