If the total is 6, what is the maximum R?
CREATE TABLE "assists" (
  "r" real,
  "player" text,
  "position" text,
  "league" real,
  "champions_league" real,
  "copa_del_rey" real,
  "total" real
);
SELECT MAX("r") FROM "assists" WHERE "total"=6;