What is the sum rating with more than 1 comp for mark miller?
CREATE TABLE table_name_78 (rating VARCHAR, player VARCHAR, comp VARCHAR)
SELECT COUNT(rating) FROM table_name_78 WHERE player = "mark miller" AND comp > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (rating VARCHAR, player VARCHAR, comp VARCHAR) Question: What is the sum rating with more than 1 comp for mark miller? [/INST] SELECT COUNT(rating) FROM table_name_78 WHERE player = "mark miller" AND comp > 1 </s>