Table: player_stats_15
Columns: player
rec
yards
avg
long

Question: How many averages have recs smaller than 26, and a Player of reggie brown, and a Long smaller than 40?
SQL: SELECT COUNT("avg") FROM player_stats_15 WHERE "rec" < 26 AND "player" = 'reggie brown' AND "long" < 40

Question: Which Yards has an Avg larger than 7, and a Long smaller than 60, and a Rec larger than 19, and a Player of correll buckhalter?
SQL: SELECT AVG("yards") FROM player_stats_15 WHERE "avg" > 7 AND "long" < 60 AND "rec" > 19 AND "player" = 'correll buckhalter'

Question: Which Yards have an avg of 11.8, and a Player of brent celek, and a Long larger than 44?
SQL: SELECT AVG("yards") FROM player_stats_15 WHERE "avg" = 11.8 AND "player" = 'brent celek' AND "long" > 44

Question: Which Yards is the highest one that has a Rec smaller than 54, and a Long smaller than 5, and a Player of todd herremans, and an Avg larger than 1?
SQL: SELECT MAX("yards") FROM player_stats_15 WHERE "rec" < 54 AND "long" < 5 AND "player" = 'todd herremans' AND "avg" > 1