Table: avengers_2007_stats
Columns: player
rec
yards
avg
td_s

Question: What is the average reception of the player with 4 touchdowns and less than 171 yards?
SQL: SELECT AVG("rec") FROM avengers_2007_stats WHERE "td_s" = 4 AND "yards" < 171

Question: What is the average that has more than 0 touchdowns and more than 135 yards?
SQL: SELECT "avg" FROM avengers_2007_stats WHERE "td_s" > 0 AND "yards" > 135