Sum of m. night shyamalan ranks?
CREATE TABLE table_name_41 (rank INTEGER, director_s_ VARCHAR)
SELECT SUM(rank) FROM table_name_41 WHERE director_s_ = "m. night shyamalan"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (rank INTEGER, director_s_ VARCHAR) Question: Sum of m. night shyamalan ranks? [/INST] SELECT SUM(rank) FROM table_name_41 WHERE director_s_ = "m. night shyamalan" </s>