Table: dance_rankings
Columns: rank_by_average
place
couple
total_points
number_of_dances
average

Question: How many dances placed below 1 with a point total of 40?
SQL: SELECT "number_of_dances" FROM dance_rankings WHERE "place" > 1 AND "total_points" = 40

Question: What is the lowest number of dances with a rank larger than 4 and a place of 8?
SQL: SELECT MIN("number_of_dances") FROM dance_rankings WHERE "rank_by_average" > 4 AND "place" = 8

Question: What is the lowest number of dances with a less than 2 place and an average smaller than 27.5?
SQL: SELECT MIN("number_of_dances") FROM dance_rankings WHERE "place" < 2 AND "average" < 27.5