CREATE TABLE table_name_5 (rank INT, name VARCHAR, appearances VARCHAR)

What was the sum of ranks of those called Fernando Cavenaghi who appeared less than 7.
SELECT SUM(rank) FROM table_name_5 WHERE name = "fernando cavenaghi" AND appearances < 7
SELECT SUM("rank") FROM "table_name_5" WHERE "appearances" < 7 AND "fernando cavenaghi" = "name"