CREATE TABLE table_name_95 (avg_g INT, gain VARCHAR, loss VARCHAR, name VARCHAR)

What is the sum of Avg/G for Dan Dierking when the Loss is 0 and the Gain is more than 34?
SELECT SUM(avg_g) FROM table_name_95 WHERE loss = 0 AND name = "dan dierking" AND gain > 34
SELECT SUM("avg_g") FROM "table_name_95" WHERE "dan dierking" = "name" AND "gain" > 34 AND "loss" = 0