a Year smaller than 2007, and a Result of 1st is in what venue?
CREATE TABLE "achievements" (
  "year" real,
  "tournament" text,
  "venue" text,
  "result" text,
  "extra" text
);
SELECT "venue" FROM "achievements" WHERE "year"<2007 AND "result"='1st';