What is the all-time rank associated with a rank less than 9 and a debut in 1994?
CREATE TABLE "appearances" (
  "rank" real,
  "all_time_rank" text,
  "name" text,
  "debut_year" real,
  "current_club" text,
  "apps" real
);
SELECT "all_time_rank" FROM "appearances" WHERE "rank"<9 AND "debut_year"=1994;