Table: player_stats_29
Columns: name
gp_gs
gain
loss
long
avg_g

Question: What's the total loss for a GP-GS of 8-8 and a gain less than 416?
SQL: SELECT SUM("loss") FROM player_stats_29 WHERE "gp_gs" = '8-8' AND "gain" < 416

Question: What's the total long for more than 24 loss, a gain over 273, and an avg/g of 207.8?
SQL: SELECT SUM("long") FROM player_stats_29 WHERE "loss" > 24 AND "gain" > 273 AND "avg_g" = 207.8

Question: What's the total long for an avg/g over 0.2, fewer than 2 loss, and a gain less than 8?
SQL: SELECT COUNT("long") FROM player_stats_29 WHERE "avg_g" > 0.2 AND "loss" < 2 AND "gain" < 8

Question: What's cameron dantley's total avg/g for loss less than 35?
SQL: SELECT COUNT("avg_g") FROM player_stats_29 WHERE "name" = 'cameron dantley' AND "loss" < 35

Question: What's the lowest avg/g for a GP-GS of 12-12 and a gain less than 16?
SQL: SELECT MIN("avg_g") FROM player_stats_29 WHERE "gp_gs" = '12-12' AND "gain" < 16