What is the lowest ranking for Paul Mctiernan?
CREATE TABLE "all_time_top_scorers" (
  "ranking" real,
  "nationality" text,
  "name" text,
  "years" text,
  "goals" real
);
SELECT MIN("ranking") FROM "all_time_top_scorers" WHERE "name"='paul mctiernan';