Date for less than 122 countries and a 47% rank?
CREATE TABLE "general" (
  "overall_ranking" text,
  "lat_am_ranking" text,
  "countries_surveyed" real,
  "pct_rank" text,
  "date" text
);
SELECT "date" FROM "general" WHERE "countries_surveyed"<122 AND "pct_rank"='47';