text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_95 (avg_g INTEGER, gain VARCHAR, loss VARCHAR, name VARCHAR)
  ### Question:
  What is the sum of Avg/G for Dan Dierking when the Loss is 0 and the Gain is more than 34?
  ### Answer:
  SELECT SUM(avg_g) FROM table_name_95 WHERE loss = 0 AND name = "dan dierking" AND gain > 34