Table: jack_clancy_receiving_stats
Columns: player
rec
yards
average
s_touchdown
year
opponent

Question: Which Rec has an Average smaller than 32, and a Touchdown smaller than 3, and an Opponent of oregon state?
SQL: SELECT SUM("rec") FROM jack_clancy_receiving_stats WHERE "average" < 32 AND "s_touchdown" < 3 AND "opponent" = 'oregon state'

Question: Which rec has Yards of 192, and a Touchdown smaller than 1?
SQL: SELECT AVG("rec") FROM jack_clancy_receiving_stats WHERE "yards" = 192 AND "s_touchdown" < 1

Question: Which Opponent has Yards smaller than 197, and an Average smaller than 32, and a Year of 1966?
SQL: SELECT "opponent" FROM jack_clancy_receiving_stats WHERE "yards" < 197 AND "average" < 32 AND "year" = 1966

Question: How many Touchdowns have a rec of 10, and an Opponent of oregon state, and an Average smaller than 19.7?
SQL: SELECT COUNT("s_touchdown") FROM jack_clancy_receiving_stats WHERE "rec" = 10 AND "opponent" = 'oregon state' AND "average" < 19.7