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_30 (long VARCHAR, gain VARCHAR, avg_g VARCHAR, loss VARCHAR)
  ### Question:
  What's the total long for an avg/g over 0.2, fewer than 2 loss, and a gain less than 8?
  ### Answer:
  SELECT COUNT(long) FROM table_name_30 WHERE avg_g > 0.2 AND loss < 2 AND gain < 8