Table: player_stats_56
Columns: name
gp_gs
gain
loss
long
avg_g

Question: What is the total gain for Brandon Mcrae with a loss less than 4, and an Avg/g less than -0.1?
SQL: SELECT COUNT("gain") FROM player_stats_56 WHERE "long" < 4 AND "name" = 'brandon mcrae' AND "avg_g" < -0.1

Question: What is the lowest long with a Gp-GS of 11-8, and a gain less than 228?
SQL: SELECT MIN("long") FROM player_stats_56 WHERE "gp_gs" = '11-8' AND "gain" < 228

Question: What is the lowest gain with an 18 long, and a loss less than 191?
SQL: SELECT MIN("gain") FROM player_stats_56 WHERE "long" = 18 AND "loss" < 191