CREATE TABLE table_name_34 (long NUMBER, loss VARCHAR2, gain VARCHAR2, gp_gs VARCHAR2, avg_g VARCHAR2)

What is the average Long that has a GP-GS less than 14, a AVg/G less than 0.8 and a Gain less than 3 and a Loss greater than 8?
SELECT AVG(long) FROM table_name_34 WHERE gp_gs < 14 AND avg_g < 0.8 AND gain < 3 AND loss > 8
SELECT AVG("long") FROM "table_name_34" WHERE "avg_g" < 0.8 AND "gain" < 3 AND "gp_gs" < 14 AND "loss" > 8