Table: dance_scores_3
Columns: rank_by_average
competition_finish
couple
total
number_of_dances
average

Question: what is the highest number where people got done at 31.1
SQL: SELECT MAX("competition_finish") FROM dance_scores_3 WHERE "average" = '31.1'

Question: who danced 11 and finished at more than a 2.0
SQL: SELECT "couple" FROM dance_scores_3 WHERE "number_of_dances" = 11 AND "competition_finish" > 2.0

Question: tell the competitions where the mean is 1
SQL: SELECT "average" FROM dance_scores_3 WHERE "number_of_dances" = 1

Question: tell the mean of the times competition for the 7 jigs
SQL: SELECT "rank_by_average" FROM dance_scores_3 WHERE "number_of_dances" = 7

Question: how many turns were completed to make a mean of 34.0
SQL: SELECT COUNT("number_of_dances") FROM dance_scores_3 WHERE "average" = '34.0'