Postgres 14

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

CREATE TABLE purchase
(
id SERIAL PRIMARY KEY,
sku TEXT NOT NULL,
date DATE NOT NULL
)
INSERT INTO Purchase(sku, date) VALUES('A123','10/02/2022');
INSERT INTO Purchase(sku, date) VALUES('C123','13/02/2022');
INSERT INTO Purchase(sku, date) VALUES('A123','11/02/2022');
INSERT INTO Purchase(sku, date) VALUES('B123','13/02/2022');
INSERT INTO Purchase(sku, date) VALUES('C123','13/02/2022');
INSERT INTO Purchase(sku, date) VALUES('A123','10/02/2022');
1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

SELECT * FROM purchase


id
sku
date


1
A123
2022-02-10

2
C123
2022-02-13

3
A123
2022-02-11

4
B123
2022-02-13

5
C123
2022-02-13

6
A123
2022-02-10

id	sku	date
1	A123	2022-02-10
2	C123	2022-02-13
3	A123	2022-02-11
4	B123	2022-02-13
5	C123	2022-02-13
6	A123	2022-02-10