Table: lamark_brown
Columns: name
gain
loss
long
avg_g

Question: Which Avg/G has a Long of 93, and a Loss smaller than 249?
SQL: SELECT SUM("avg_g") FROM lamark_brown WHERE "long" = 93 AND "loss" < 249

Question: Which Avg/G has a Name of josh freeman, and a Loss smaller than 134?
SQL: SELECT SUM("avg_g") FROM lamark_brown WHERE "name" = 'josh freeman' AND "loss" < 134

Question: How much Gain has a Long of 29, and an Avg/G smaller than 33.7?
SQL: SELECT COUNT("gain") FROM lamark_brown WHERE "long" = 29 AND "avg_g" < 33.7