Table: t_2007_dallas_desperados_player
Columns: player
car
yards
avg
td_s
long

Question: What is the average for the RB with an 8 yard long?
SQL: SELECT COUNT("avg") FROM t_2007_dallas_desperados_player WHERE "long" = 8

Question: How many yards for the RB with over 4 carries, 2 TDs, and a long greater than 8?
SQL: SELECT COUNT("yards") FROM t_2007_dallas_desperados_player WHERE "car" > 4 AND "td_s" = 2 AND "long" > 8