CREATE TABLE table_7837 ("Rank" FLOAT, "Title" CLOB, "Studio" CLOB, "Director" CLOB, "Gross" CLOB)

WHAT IS THE RANK OF MARTIN BREST?
SELECT SUM("Rank") FROM table_7837 WHERE "Director" = 'martin brest'
SELECT SUM("Rank") FROM "table_7837" WHERE "Director" = 'martin brest'