What was the highest rank by average of a couple who had an average of 25.3 and had more than 10 dances?
CREATE TABLE table_name_27 (rank_by_average INTEGER, average VARCHAR, number_of_dances VARCHAR)
SELECT MAX(rank_by_average) FROM table_name_27 WHERE average = 25.3 AND number_of_dances > 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (rank_by_average INTEGER, average VARCHAR, number_of_dances VARCHAR) Question: What was the highest rank by average of a couple who had an average of 25.3 and had more than 10 dances? [/INST] SELECT MAX(rank_by_average) FROM table_name_27 WHERE average = 25.3 AND number_of_dances > 10 </s>