What is the average number of games of the player with a rank less than 1?
CREATE TABLE "points" (
  "rank" real,
  "name" text,
  "team" text,
  "games" real,
  "points" real
);
SELECT AVG("games") FROM "points" WHERE "rank"<1;