What is the rank by average where the total was larger than 245 and the average was 27.1 with fewer than 15 dances?
CREATE TABLE table_name_43 (rank_by_average INTEGER, number_of_dances VARCHAR, total VARCHAR, average VARCHAR)
SELECT AVG(rank_by_average) FROM table_name_43 WHERE total > 245 AND average = 27.1 AND number_of_dances < 15
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (rank_by_average INTEGER, number_of_dances VARCHAR, total VARCHAR, average VARCHAR) Question: What is the rank by average where the total was larger than 245 and the average was 27.1 with fewer than 15 dances? [/INST] SELECT AVG(rank_by_average) FROM table_name_43 WHERE total > 245 AND average = 27.1 AND number_of_dances < 15 </s>