Who had a rank more than 48, and a last in 2005?
CREATE TABLE "women" (
  "rank" real,
  "name" text,
  "confederation" text,
  "caps" real,
  "last" real
);
SELECT "name" FROM "women" WHERE "rank">48 AND "last"=2005;