Table: blaze_2007_stats
Columns: player
car
yards
avg
td_s
long

Question: How many carries for the player with under 6 yards and an average of over 5?
SQL: SELECT COUNT("car") FROM blaze_2007_stats WHERE "yards" < 6 AND "avg" > 5

Question: What was the longest carry for kevin clemens with under 31 yards total?
SQL: SELECT MAX("long") FROM blaze_2007_stats WHERE "player" = 'kevin clemens' AND "yards" < 31

Question: How many TDs for the player with a long of less than 4 and under 8 yards?
SQL: SELECT SUM("td_s") FROM blaze_2007_stats WHERE "long" < 4 AND "yards" < 8

Question: What is the average for the player with 1 TD, over 4 as a long, and under 1 carry?
SQL: SELECT MIN("avg") FROM blaze_2007_stats WHERE "td_s" = 1 AND "long" > 4 AND "car" < 1