CREATE TABLE table_name_43 (rank_by_average NUMBER, number_of_dances VARCHAR2, total VARCHAR2, average VARCHAR2)

What is the rank by average where the total was larger than 245 and the average was 27.1 with fewer than 15 dances?
SELECT AVG(rank_by_average) FROM table_name_43 WHERE total > 245 AND average = 27.1 AND number_of_dances < 15
SELECT AVG("rank_by_average") FROM "table_name_43" WHERE "average" = 27.1 AND "number_of_dances" < 15 AND "total" > 245