CREATE TABLE table_45195 ("Rank" FLOAT, "Title" CLOB, "Studio" CLOB, "Director ( s ) " CLOB, "Worldwide Gross" CLOB)

Sum of m. night shyamalan ranks?
SELECT SUM("Rank") FROM table_45195 WHERE "Director(s)" = 'm. night shyamalan'
SELECT SUM("Rank") FROM "table_45195" WHERE "Director(s)" = 'm. night shyamalan'