user: Question: How many yards have a Player of james macpherson, and a Long smaller than 1?
Columns: ['Player', 'Car.', 'Yards', 'Avg.', "TD's", 'Long']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Matt Huebner', 34.0, 122.0, 3.6, 5.0, 24.0]
SQL:

assistant: SELECT "Yards" FROM "Table" WHERE "Player" = 'james macpherson' AND "Long" < 1.0;