Table: force_2006_stats
Columns: player
rec
yards
avg
td_s
long

Question: what is the least yards when the average is 7 and the long is less than 7?
SQL: SELECT MIN("yards") FROM force_2006_stats WHERE "avg" = 7 AND "long" < 7

Question: what is the average td's for the player jacques rumph with yards more than 214?
SQL: SELECT AVG("td_s") FROM force_2006_stats WHERE "player" = 'jacques rumph' AND "yards" > 214