How many years have an accolade of 50 best albums of the year, with #3 as the rank?
CREATE TABLE "accolades" (
  "publication" text,
  "country" text,
  "accolade" text,
  "year" real,
  "rank" text
);
SELECT SUM("year") FROM "accolades" WHERE "accolade"='50 best albums of the year' AND "rank"='#3';