Quantas jardas tem um jogador de James Macpherson, e um Long menor que 1?
CREATE TABLE table_name_6 (yards VARCHAR, player VARCHAR, long VARCHAR)
SELECT COUNT(yards) FROM table_name_6 WHERE player = "james macpherson" AND long < 1