Qual era a soma das fileiras daqueles chamados Fernando Cavenaghi que apareceram menos de 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