Name the sum of rank by average with competition finish more than 8 and average larger than 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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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 [/INST] SELECT SUM(rank_by_average) FROM table_name_29 WHERE competition_finish > 8 AND average > 30 </s>