Table: football_stats_2007_2
Columns: player
rec
yards
avg
td_s
long

Question: Tell me the lowest avg for 6 yards and rec more than 1
SQL: SELECT MIN("avg") FROM football_stats_2007_2 WHERE "yards" = 6 AND "rec" > 1

Question: Name the sum of long for avg more than 9.8 with rec less than 5 and yards less than 20
SQL: SELECT SUM("long") FROM football_stats_2007_2 WHERE "avg" > 9.8 AND "rec" < 5 AND "yards" < 20

Question: Name the sum of long for avg less than 6 and rec less than 2
SQL: SELECT SUM("long") FROM football_stats_2007_2 WHERE "avg" < 6 AND "rec" < 2

Question: Name the average TD's for andy mccullough with yards less than 434
SQL: SELECT AVG("td_s") FROM football_stats_2007_2 WHERE "player" = 'andy mccullough' AND "yards" < 434