Table: williams_e
Columns: name
gain
loss
long
avg_g

Question: What is the total number of losses of the player with an avg/g smaller than -3.3 and a gain larger than 126?
SQL: SELECT COUNT("loss") FROM williams_e WHERE "avg_g" < -3.3 AND "gain" > 126

Question: What is the total number of losses Jackson, T., who had more than 27 gain, an avg/g smaller than 55.9, and a long less than 34, had?
SQL: SELECT COUNT("loss") FROM williams_e WHERE "gain" > 27 AND "avg_g" < 55.9 AND "name" = 'jackson, t.' AND "long" < 34

Question: What is the total number of long Dubose, E., who had 0 losses, a gain less than 17, and an avg/g bigger than 0, had?
SQL: SELECT COUNT("long") FROM williams_e WHERE "loss" = 0 AND "gain" < 17 AND "avg_g" > 0 AND "name" = 'dubose, e.'