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_45 (long VARCHAR, name VARCHAR, avg_g VARCHAR, loss VARCHAR, gain VARCHAR)
  ### Question:
  What is the total number of long Dubose, E., who had 0 losses, a gain less than 17, and an avg/g bigger than 0, had?
  ### Answer:
  SELECT COUNT(long) FROM table_name_45 WHERE loss = 0 AND gain < 17 AND avg_g > 0 AND name = "dubose, e."