user: ### NOW ANSWER:
Question: Sum of M. Night Shyamalan ranks?
Columns: ['Rank', 'Title', 'Studio', 'Director(s)', 'Worldwide Gross']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'The Lord of the Rings: The Two Towers', 'New Line Cinema', 'Peter Jackson', '$925,282,504']
SQL:

assistant: SELECT SUM("Rank") FROM "Table" WHERE "Director(s)" = 'M. Night Shyamalan';