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_29 (rank_by_average INTEGER, competition_finish VARCHAR, average VARCHAR)
  ### Question:
  Name the sum of rank by average with competition finish more than 8 and average larger than 30
  ### Answer:
  SELECT SUM(rank_by_average) FROM table_name_29 WHERE competition_finish > 8 AND average > 30