Nomear a soma da classificação por média com competição final superior a 8 e média superior a 30
CREATE TABLE table_name_29 (rank_by_average INTEGER, competition_finish VARCHAR, average VARCHAR)
SELECT SUM(rank_by_average) FROM table_name_29 WHERE competition_finish > 8 AND average > 30