I want to know the player with tries more than 1 and position of hooker with points less than 54
CREATE TABLE "1996_squad_statistics" (
  "player" text,
  "position" text,
  "tries" real,
  "goals" real,
  "points" real
);
SELECT "player" FROM "1996_squad_statistics" WHERE "tries">1 AND "points"<54 AND "position"='hooker';