Table: joe_hall
Columns: name
gain
loss
long
avg_g

Question: How much Loss has a Gain smaller than 1571, and a Long smaller than 47, and an Avg/G of 36.4?
SQL: SELECT COUNT("loss") FROM joe_hall WHERE "gain" < 1571 AND "long" < 47 AND "avg_g" = 36.4

Question: Which Avg/G has a Name of david allen, and a Gain larger than 371?
SQL: SELECT AVG("avg_g") FROM joe_hall WHERE "name" = 'david allen' AND "gain" > 371

Question: Which Avg/G is the lowest one that has a Long smaller than 47, and a Name of frank murphy, and a Gain smaller than 569?
SQL: SELECT MIN("avg_g") FROM joe_hall WHERE "long" < 47 AND "name" = 'frank murphy' AND "gain" < 569

Question: How much Avg/G has a Gain smaller than 1571, and a Long smaller than 46?
SQL: SELECT COUNT("avg_g") FROM joe_hall WHERE "gain" < 1571 AND "long" < 46