CREATE TABLE table_name_29 (rank_by_average INT, competition_finish VARCHAR, average VARCHAR)

Name the sum of rank by average with competition finish more than 8 and average larger than 30
SELECT SUM(rank_by_average) FROM table_name_29 WHERE competition_finish > 8 AND average > 30
SELECT SUM("rank_by_average") FROM "table_name_29" WHERE "average" > 30 AND "competition_finish" > 8