Table: dragons_2007_stats
Columns: player
car
yards
avg
td_s
long

Question: How many carries for the RB averaging 4.7, and a long of over 30 yards?
SQL: SELECT SUM("car") FROM dragons_2007_stats WHERE "avg" = 4.7 AND "long" > 30

Question: How many yards did kevin swayne average, with a long carry over 7?
SQL: SELECT MIN("avg") FROM dragons_2007_stats WHERE "player" = 'kevin swayne' AND "long" > 7

Question: How many yards for the player with over 0 TDs and an average of 2.9?
SQL: SELECT MIN("yards") FROM dragons_2007_stats WHERE "td_s" > 0 AND "avg" = 2.9

Question: How many TDs for the player averaging over 7, and over 39 yards?
SQL: SELECT MIN("td_s") FROM dragons_2007_stats WHERE "avg" > 7 AND "yards" > 39