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?
CREATE TABLE table_name_34 (
    long INTEGER,
    loss VARCHAR,
    gain VARCHAR,
    gp_gs VARCHAR,
    avg_g VARCHAR
)
SELECT AVG(long) FROM table_name_34 WHERE gp_gs < 14 AND avg_g < 0.8 AND gain < 3 AND loss > 8
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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? ### Input: CREATE TABLE table_name_34 (
    long INTEGER,
    loss VARCHAR,
    gain VARCHAR,
    gp_gs VARCHAR,
    avg_g VARCHAR
) ### Response: SELECT AVG(long) FROM table_name_34 WHERE gp_gs < 14 AND avg_g < 0.8 AND gain < 3 AND loss > 8