Table: bullock_chris
Columns: name
gain
loss
long
avg_g

Question: Which Avg/G has a Gain of 16, and a Name of barnes, freddie, and a Loss smaller than 2?
SQL: SELECT SUM("avg_g") FROM bullock_chris WHERE "gain" = 16 AND "name" = 'barnes, freddie' AND "loss" < 2

Question: Which average Long has a Gain smaller than 16, and a Loss smaller than 6?
SQL: SELECT AVG("long") FROM bullock_chris WHERE "gain" < 16 AND "loss" < 6

Question: Which Gain is the lowest one that has a Loss larger than 2, and an Avg/G larger than -6, and a Name of sheehan, tyler, and a Long larger than 11?
SQL: SELECT MIN("gain") FROM bullock_chris WHERE "loss" > 2 AND "avg_g" > -6 AND "name" = 'sheehan, tyler' AND "long" > 11

Question: Which Avg/G is the lowest one that has a Long larger than 8, and a Loss smaller than 34, and a Gain larger than 16, and a Name of bullock, chris?
SQL: SELECT MIN("avg_g") FROM bullock_chris WHERE "long" > 8 AND "loss" < 34 AND "gain" > 16 AND "name" = 'bullock, chris'

Question: Which Loss has a Name of bullock, chris, and a Long smaller than 36?
SQL: SELECT SUM("loss") FROM bullock_chris WHERE "name" = 'bullock, chris' AND "long" < 36

Question: How much Long has a Loss larger than 2, and a Gain of 157, and an Avg/G smaller than 129?
SQL: SELECT SUM("long") FROM bullock_chris WHERE "loss" > 2 AND "gain" = 157 AND "avg_g" < 129