Table: t_2007_avengers_rushing_stats
Columns: player
car
yards
avg
td_s
long

Question: Which Player had a Long of 5 and Yards of 6?
SQL: SELECT "player" FROM t_2007_avengers_rushing_stats WHERE "long" = '5' AND "yards" = '6'

Question: What was the total number of TD's for Player Lashaun Ward while also having a Long of 2?
SQL: SELECT COUNT("td_s") FROM t_2007_avengers_rushing_stats WHERE "long" = '2' AND "player" = 'lashaun ward'

Question: How many Yards did Player Rob Turner collect?
SQL: SELECT "yards" FROM t_2007_avengers_rushing_stats WHERE "player" = 'rob turner'