What's the most flags that had 473 wins and less than 633 losses?
CREATE TABLE "win_loss_record" (
  "club" text,
  "active" text,
  "wins" real,
  "losses" real,
  "draws" real,
  "percentage_wins" text,
  "flags" real
);
SELECT MAX("flags") FROM "win_loss_record" WHERE "wins"=473 AND "losses"<633;