Which Definition has a Rank smaller than 12, and a Town of tadcaster?
CREATE TABLE "settlements_by_population" (
  "rank" real,
  "town" text,
  "population" real,
  "year" real,
  "borough" text,
  "definition" text
);
SELECT "definition" FROM "settlements_by_population" WHERE "rank"<12 AND "town"='tadcaster';