What is the sum of Rank when Pat Onstad was the goalkeeper?
CREATE TABLE table_name_30 (rank INTEGER, goalkeeper VARCHAR)
SELECT SUM(rank) FROM table_name_30 WHERE goalkeeper = "pat onstad"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (rank INTEGER, goalkeeper VARCHAR) Question: What is the sum of Rank when Pat Onstad was the goalkeeper? [/INST] SELECT SUM(rank) FROM table_name_30 WHERE goalkeeper = "pat onstad" </s>