Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS "transaction" (DATE_ID BIGINT NOT NULL, STORE_ID INT NOT NULL, TRANSACTION_TYPE_ID CHAR(1) NOT NULL, PRODUCT_ID INT NOT NULL, QTY INT NOT NULL);

INSERT INTO "transaction" (DATE_ID, STORE_ID, TRANSACTION_TYPE_ID, PRODUCT_ID, QTY) VALUES (1, 1, 'A', 1, 2), (1, 1, 'B', 1, 1), (1, 2, 'A', 4, 1), (1, 6, 'A', 3, 1), (1, 1, 'A', 1, 1), (2, 1, 'B', 1, 1), (2, 1, 'A', 1, 1), (2, 2, 'A', 2, 5), (3, 2, 'A', 2, 7), (3, 3, 'A', 2, 1), (3, 3, 'B', 1, 15), (3, 3, 'A', 1, 1), (4, 4, 'A', 1, 1), (4, 4, 'A', 1, 5), (4, 4, 'A', 1, 11), (4, 5, 'A', 3, 2), (4, 6, 'A', 3, 1), (4, 6, 'A', 3, 1), (4, 6, 'B', 2, 1), (5, 2, 'A', 2, 2), (5, 2, 'B', 1, 1), (5, 2, 'A', 2, 1), (5, 2, 'A', 4, 1), (5, 2, 'A', 5, 1), (6, 2, 'B', 4, 1), (6, 2, 'A', 6, 1), (6, 3, 'A', 3, 5), (7, 3, 'A', 2, 7), (7, 4, 'A', 2, 1), (7, 4, 'B', 2, 15), (7, 4, 'A', 2, 1), (7, 5, 'A', 2, 1), (7, 5, 'A', 2, 5), (7, 5, 'A', 2, 11), (7, 6, 'A', 2, 2), (7, 1, 'A', 2, 1), (8, 1, 'A', 2, 1), (8, 1, 'B', 2, 1), (8, 3, 'A', 3, 2), (9, 3, 'B', 3, 1), (9, 3, 'A', 3, 1), (9, 3, 'A', 3, 1), (9, 3, 'A', 3, 1), (10, 3, 'B', 3, 1), (10, 3, 'A', 3, 1), (10, 4, 'A', 4, 5), (10, 4, 'A', 4, 7), (10, 5, 'A', 5, 1), (10, 5, 'B', 5, 15), (10, 5, 'A', 5, 1), (10, 6, 'A', 6, 1), (10, 6, 'A', 6, 5), (10, 6, 'A', 6, 11), (10, 1, 'A', 1, 2), (10, 2, 'A', 2, 1), (11, 2, 'A', 2, 1), (11, 2, 'B', 2, 1), (11, 3, 'A', 5, 2), (11, 3, 'B', 5, 1), (11, 3, 'A', 5, 1), (12, 3, 'A', 5, 1), (12, 3, 'A', 5, 1)

CREATE TABLE

INSERT 0 62

product_id
5

SELECT 1