What is the sum of Avg/G for Dan Dierking when the Loss is 0 and the Gain is more than 34?
CREATE TABLE table_name_95 (
    avg_g INTEGER,
    gain VARCHAR,
    loss VARCHAR,
    name VARCHAR
)
SELECT SUM(avg_g) FROM table_name_95 WHERE loss = 0 AND name = "dan dierking" AND gain > 34
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 sum of Avg/G for Dan Dierking when the Loss is 0 and the Gain is more than 34? ### Input: CREATE TABLE table_name_95 (
    avg_g INTEGER,
    gain VARCHAR,
    loss VARCHAR,
    name VARCHAR
) ### Response: SELECT SUM(avg_g) FROM table_name_95 WHERE loss = 0 AND name = "dan dierking" AND gain > 34