Table: trevor_cobb_1989_stats
Columns: year
games
rushes
rushing_yards
rushing_tds
receptions
receiving_yards
receiving_tds

Question: How many receptions were smaller than 161 receiving yards but also had less than 14 rushing TDs?
SQL: SELECT COUNT("receptions") FROM trevor_cobb_1989_stats WHERE "receiving_yards" < 161 AND "rushing_tds" < 14

Question: What was the greatest number of rushing yards for a runner who had 283 rushes and less than 10 rushing TDs?
SQL: SELECT MAX("rushing_yards") FROM trevor_cobb_1989_stats WHERE "rushes" = 283 AND "rushing_tds" < 10