Which party won in 2003, that had a swing to gain of less than 2.92 and which resulted in a ld hold?
CREATE TABLE "snp_targets" (
  "rank" real,
  "constituency" text,
  "winning_party_2003" text,
  "swing_to_gain" real,
  "snp_s_place_2003" text,
  "result" text
);
SELECT "winning_party_2003" FROM "snp_targets" WHERE "swing_to_gain"<2.92 AND "result"='ld hold';