Table: josh_scobey
Columns: name
gain
loss
long
avg_g

Question: What was the highest long with less than 7 losses and an Avg/G smaller than 25.1?
SQL: SELECT MAX("long") FROM josh_scobey WHERE "loss" < 7 AND "avg_g" < 25.1

Question: What was Rock Cartwright's highest long with more than 11 losses?
SQL: SELECT AVG("long") FROM josh_scobey WHERE "name" = 'rock cartwright' AND "loss" > 11