If the total is 6, what is the maximum R?
CREATE TABLE table (r INTEGER, total VARCHAR)
SELECT MAX(r) FROM table WHERE total = 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table (r INTEGER, total VARCHAR) Question: If the total is 6, what is the maximum R? [/INST] SELECT MAX(r) FROM table WHERE total = 6 </s>