Table: t_9_6_chris_asbury
Columns: name
gp_gs
gain
loss
long
avg_g

Question: which Name has a Loss larger than 2, and a Avg/G larger than -16, and a GP-GS of 11–7, and a Gain larger than 86?
SQL: SELECT "name" FROM t_9_6_chris_asbury WHERE "loss" > 2 AND "avg_g" > -16 AND "gp_gs" = '11–7' AND "gain" > 86

Question: Name the highest Long that has an Avg/G smaller than 8.4, and an GP-GS of 4–0?
SQL: SELECT MAX("long") FROM t_9_6_chris_asbury WHERE "avg_g" < 8.4 AND "gp_gs" = '4–0'

Question: Name the lowest Gain which has a Long of 0, and a GP-GS of 4–0, and a Loss smaller than 3?
SQL: SELECT MIN("gain") FROM t_9_6_chris_asbury WHERE "long" = 0 AND "gp_gs" = '4–0' AND "loss" < 3

Question: Name the total of Loss which has an Avg/G of 8.4?
SQL: SELECT COUNT("loss") FROM t_9_6_chris_asbury WHERE "avg_g" = 8.4