Table: dancing_scores
Columns: rank_by_average
competition_finish
couple
total
number_of_dances
average

Question: Name the most total with average less than 36.5 and rank by average of 14
SQL: SELECT MAX("total") FROM dancing_scores WHERE "average" < 36.5 AND "rank_by_average" = 14

Question: Name the sum of rank by average with competition finish more than 8 and average larger than 30
SQL: SELECT SUM("rank_by_average") FROM dancing_scores WHERE "competition_finish" > 8 AND "average" > 30

Question: Name the total number of competition finish with total of 90 and rank by average more than 5
SQL: SELECT COUNT("competition_finish") FROM dancing_scores WHERE "total" = 90 AND "rank_by_average" > 5

Question: Name the greatest competition finish with average more than 32.9 and number of dances more than 16
SQL: SELECT MAX("competition_finish") FROM dancing_scores WHERE "average" > 32.9 AND "number_of_dances" > 16

Question: Name the least rank by average for number of dances less than 9 and competition finish of 5
SQL: SELECT MIN("rank_by_average") FROM dancing_scores WHERE "competition_finish" = 5 AND "number_of_dances" < 9