What is the year average when not free was the status, and less than 7 was the civil liberties, and less than 6 political rights?
CREATE TABLE "historical_rankings" (
  "year" real,
  "political_rights" real,
  "civil_liberties" real,
  "status" text,
  "president" text
);
SELECT AVG("year") FROM "historical_rankings" WHERE "status"='not free' AND "civil_liberties"<7 AND "political_rights"<6;