How many skaters have a Rank in FS of 3, and a Rank in SP larger than 4?
CREATE TABLE "program_details" (
  "final_rank" real,
  "skater" text,
  "rank_in_sp" real,
  "rank_in_fs" real,
  "total_score" text
);
SELECT COUNT("final_rank") FROM "program_details" WHERE "rank_in_fs"=3 AND "rank_in_sp">4;