CREATE TABLE "active_bonus"
(
    "tmstmp"    TMSTMP NOT NULL,
    "user_id"   ID NOT NULL,
    "bonus_id"  ID NOT NULL,
  CONSTRAINT "active_bonus__pk" PRIMARY KEY ("user_id", "tmstmp")
);

INSERT INTO "active_bonus" ("tmstmp", "user_id", "bonus_id")
        SELECT CURRENT_TIMESTAMP-10, 1, 4 FROM oneRow
  UNION SELECT CURRENT_TIMESTAMP-2, 2, 3 FROM oneRow
  UNION SELECT CURRENT_TIMESTAMP-5, 2, 8 FROM oneRow
  UNION SELECT CURRENT_TIMESTAMP-20, 3, 8 FROM oneRow
  UNION SELECT CURRENT_TIMESTAMP-3, 3, 3 FROM oneRow
  UNION SELECT CURRENT_TIMESTAMP-9, 3, 4 FROM oneRow;

WITH "last" AS
(
  SELECT "user_id", Max("tmstmp") AS "tmstmp"
    FROM "active_bonus"
    GROUP BY "user_id"
)
SELECT ab."user_id", ab."bonus_id", ab."tmstmp"
  FROM "active_bonus" ab
    INNER JOIN "last" l
      ON l."user_id" = ab."user_id" AND l."tmstmp" = ab."tmstmp"

CREATE OR ALTER VIEW "bonus"
AS
WITH "last" AS
(
  SELECT "user_id", Max("tmstmp") AS "tmstmp"
    FROM "active_bonus"
    GROUP BY "user_id"
)
SELECT ab."user_id", ab."bonus_id",
    Iif(l."user_id" IS NULL, _ASCII 'inactive', _ASCII 'active') AS "status"
  FROM "active_bonus" ab
    LEFT JOIN "last" l
      ON l."user_id" = ab."user_id" AND l."tmstmp" = ab."tmstmp"

CREATE TABLE "active_bonus"
(
    "tmstmp"    TMSTMP NOT NULL,
    "user_id"   ID NOT NULL,
    "bonus_id"  ID NOT NULL,
  CONSTRAINT "active_bonus__pk" PRIMARY KEY ("user_id", "tmstmp")
);