Table: t_2007_kansas_city_brigade
Columns: player
rec
yards
avg
td_s

Question: What is the average number of TDs when the yards are less than 119, the AVG is larger than 5, and Jamarr Ward is a player?
SQL: SELECT AVG("td_s") FROM t_2007_kansas_city_brigade WHERE "yards" < 119 AND "player" = 'jamarr ward' AND "avg" > 5

Question: What is the total Avg when TDs are 0 and Dawan Moss is a player?
SQL: SELECT COUNT("avg") FROM t_2007_kansas_city_brigade WHERE "player" = 'dawan moss' AND "td_s" < 0

Question: What is the highest number of TDs when the Avg is larger than 8.5 and the Rec is less than 1?
SQL: SELECT MAX("td_s") FROM t_2007_kansas_city_brigade WHERE "avg" > 8.5 AND "rec" < 1