CREATE TABLE table_name_41 (rank INT, director_s_ VARCHAR)

Sum of m. night shyamalan ranks?
SELECT SUM(rank) FROM table_name_41 WHERE director_s_ = "m. night shyamalan"
SELECT SUM("rank") FROM "table_name_41" WHERE "director_s_" = "m. night shyamalan"