CREATE TABLE table_name_93 (rank NUMBER, director VARCHAR2)

WHAT IS THE RANK OF MARTIN BREST?
SELECT SUM(rank) FROM table_name_93 WHERE director = "martin brest"
SELECT SUM("rank") FROM "table_name_93" WHERE "director" = "martin brest"