What was the sum of ranks of those called Fernando Cavenaghi who appeared less than 7.
CREATE TABLE table_name_5 (rank INTEGER, name VARCHAR, appearances VARCHAR)
SELECT SUM(rank) FROM table_name_5 WHERE name = "fernando cavenaghi" AND appearances < 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_5 (rank INTEGER, name VARCHAR, appearances VARCHAR) Question: What was the sum of ranks of those called Fernando Cavenaghi who appeared less than 7. [/INST] SELECT SUM(rank) FROM table_name_5 WHERE name = "fernando cavenaghi" AND appearances < 7 </s>