Table: force_2007_stats
Columns: player
car
yards
avg
td_s
long

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

Question: How many averages have a TD's of 6, and more than 25 yards?
SQL: SELECT COUNT("avg") FROM force_2007_stats WHERE "td_s" = 6 AND "yards" > 25

Question: What is the lowest car with more than 122 yards?
SQL: SELECT MIN("car") FROM force_2007_stats WHERE "yards" > 122