CREATE TABLE table_78274 ("Player" TEXT, "Rec." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "TD's" FLOAT, "Long" FLOAT)

What is the average for wes ours with over 1 reception and under 1 TD?
SELECT SUM("Avg.") FROM table_78274 WHERE "Rec." > '1' AND "Player" = 'wes ours' AND "TD's" < '1'
SELECT SUM("Avg.") FROM "table_78274" WHERE "Player" = 'wes ours' AND "Rec." > '1' AND "TD's" < '1'