What's the average year with a rank less than 3?
CREATE TABLE "accolades" (
  "year" real,
  "publication" text,
  "country" text,
  "accolade" text,
  "rank" real
);
SELECT AVG("year") FROM "accolades" WHERE "rank"<3;