Table: derrick_locke
Columns: name
gp_gs
gain
loss
long
avg_g

Question: What is the long figure when gain is less than 0?
SQL: SELECT AVG("long") FROM derrick_locke WHERE "gain" < 0

Question: What is the loss when the average/gain is less than 16.7, gain is 104 and long is larger than 4?
SQL: SELECT AVG("loss") FROM derrick_locke WHERE "avg_g" < 16.7 AND "long" > 4 AND "gain" = 104