Table: willie_heston_stats
Columns: year
carries
rushing_yards
average
touchdowns
points

Question: How many carries have an average under 8.7 and touchdowns of 72?
SQL: SELECT COUNT("carries") FROM willie_heston_stats WHERE "average" < 8.7 AND "touchdowns" = 72

Question: What is the average number of carries that have more than 72 touchdowns?
SQL: SELECT AVG("carries") FROM willie_heston_stats WHERE "touchdowns" > 72

Question: What is the most number of touchdowns that have fewer than 105 points, averages over 4.7, and fewer than 487 rushing yards?
SQL: SELECT MAX("touchdowns") FROM willie_heston_stats WHERE "points" < 105 AND "average" > 4.7 AND "rushing_yards" < 487

Question: What is the sum of carries associated with 80 points and fewer than 16 touchdowns?
SQL: SELECT SUM("carries") FROM willie_heston_stats WHERE "points" = 80 AND "touchdowns" < 16

Question: What is the total number of rushing yards associated with averages over 8.4 and fewer than 54 carries?
SQL: SELECT COUNT("rushing_yards") FROM willie_heston_stats WHERE "average" > 8.4 AND "carries" < 54