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

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'