What years had a ranking of 1?
CREATE TABLE "top_scorers_in_loi" (
  "ranking" real,
  "nationality" text,
  "name" text,
  "years" text,
  "goals" real
);
SELECT "years" FROM "top_scorers_in_loi" WHERE "ranking"=1;