What is the sum of totals for ranks under 3 with tallies of 2-5?
CREATE TABLE table_name_94 (total INTEGER, rank VARCHAR, tally VARCHAR)
SELECT SUM(total) FROM table_name_94 WHERE rank < 3 AND tally = "2-5"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_94 (total INTEGER, rank VARCHAR, tally VARCHAR) Question: What is the sum of totals for ranks under 3 with tallies of 2-5? [/INST] SELECT SUM(total) FROM table_name_94 WHERE rank < 3 AND tally = "2-5" </s>