Table: dwtstars_season7_scores
Columns: rank_by_average
place
couple
total_points
number_of_dances
average

Question: What is the total rank with more than 392 total points and an 24.8 average?
SQL: SELECT COUNT("rank_by_average") FROM dwtstars_season7_scores WHERE "total_points" > 392 AND "average" = 24.8

Question: What is the highest average with less than 3 places, less than 433 total points, and a rank less than 2?
SQL: SELECT MAX("average") FROM dwtstars_season7_scores WHERE "place" < 3 AND "total_points" < 433 AND "rank_by_average" < 2

Question: What is the total average with 54 total points and a rank less than 10?
SQL: SELECT COUNT("average") FROM dwtstars_season7_scores WHERE "total_points" = 54 AND "rank_by_average" < 10

Question: What is the total rank by average for 2 dances, which have more than 37 total points?
SQL: SELECT COUNT("rank_by_average") FROM dwtstars_season7_scores WHERE "number_of_dances" = 2 AND "total_points" > 37