Sum of m. night shyamalan ranks?
CREATE TABLE "highest_grossing_films_of_2002" (
  "rank" real,
  "title" text,
  "studio" text,
  "director_s" text,
  "worldwide_gross" text
);
SELECT SUM("rank") FROM "highest_grossing_films_of_2002" WHERE "director_s"='m. night shyamalan';