Table: t_2006_kansas_city_brigade
Columns: player
rec
yards
avg
td_s
long

Question: What is the sum of averages with a long value of 32?
SQL: SELECT SUM("avg") FROM t_2006_kansas_city_brigade WHERE "long" = 32

Question: What is the highest TD's with less than 15 yards and less than 1 rec.?
SQL: SELECT MAX("td_s") FROM t_2006_kansas_city_brigade WHERE "yards" < 15 AND "rec" < 1