what is the total scored for the 8th position and a score more than 6.6
CREATE TABLE table_name_8 (total INTEGER, position VARCHAR, a_score VARCHAR)
SELECT MAX(total) FROM table_name_8 WHERE position = "8th" AND a_score > 6.6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (total INTEGER, position VARCHAR, a_score VARCHAR) Question: what is the total scored for the 8th position and a score more than 6.6 [/INST] SELECT MAX(total) FROM table_name_8 WHERE position = "8th" AND a_score > 6.6 </s>