What is the sum of all ratings at a weekly rank of 10 and a share less than 11?
CREATE TABLE table_name_33 (rating INTEGER, weekly_rank___number_ VARCHAR, share VARCHAR)
SELECT SUM(rating) FROM table_name_33 WHERE weekly_rank___number_ = "10" AND share < 11
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_33 (rating INTEGER, weekly_rank___number_ VARCHAR, share VARCHAR) Question: What is the sum of all ratings at a weekly rank of 10 and a share less than 11? [/INST] SELECT SUM(rating) FROM table_name_33 WHERE weekly_rank___number_ = "10" AND share < 11 </s>