What is the lowest number of dances with a rank larger than 4 and a place of 8?
CREATE TABLE "averages" (
  "rank_by_average" real,
  "place" real,
  "couple" text,
  "total_points" real,
  "number_of_dances" real,
  "average" real
);
SELECT MIN("number_of_dances") FROM "averages" WHERE "rank_by_average">4 AND "place"=8;