Table: player_stats_2007
Columns: player
rec
yards
avg
td_s
long

Question: What is the average for wes ours with over 1 reception and under 1 TD?
SQL: SELECT SUM("avg") FROM player_stats_2007 WHERE "rec" > 1 AND "player" = 'wes ours' AND "td_s" < 1

Question: How many receptions for players with over 647 yards and an under 14 yard average?
SQL: SELECT MIN("rec") FROM player_stats_2007 WHERE "yards" > 647 AND "avg" < 14