Which Rank has a Losing Semi- finalist larger than 1, and a Winner smaller than 5?
CREATE TABLE "top_countries" (
  "rank" real,
  "country" text,
  "winner" real,
  "runner_up" real,
  "losing_semi_finalist" real
);
SELECT "rank" FROM "top_countries" WHERE "losing_semi_finalist">1 AND "winner"<5;