What player has a rating greater than 2746, with a prev less than 4, and +4 as the chng?
CREATE TABLE "fide_april_2008_top_ten" (
  "rank" real,
  "prev" real,
  "player" text,
  "rating" real,
  "chng" text
);
SELECT "player" FROM "fide_april_2008_top_ten" WHERE "rating">2746 AND "prev"<4 AND "chng"='+4';