What is the total number of ranks when the Peak Name is Red Shirt Table?
CREATE TABLE table_name_51 (rank INTEGER, peak_name VARCHAR)
SELECT SUM(rank) FROM table_name_51 WHERE peak_name = "red shirt table"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_51 (rank INTEGER, peak_name VARCHAR) Question: What is the total number of ranks when the Peak Name is Red Shirt Table? [/INST] SELECT SUM(rank) FROM table_name_51 WHERE peak_name = "red shirt table" </s>