what rank has years until mandatory retirement of 6 years?
CREATE TABLE "current_composition" (
  "name" text,
  "rank" text,
  "years_until_mandatory_retirement" text,
  "appointed_by" text,
  "year_appointed" real
);
SELECT "rank" FROM "current_composition" WHERE "years_until_mandatory_retirement"='6 years';