Postgres 15

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

create table product (Product 	varchar(100),
  Date 	date, Value int);

CREATE TABLE


insert into product values ('Product 1', '2022-12-01', 200);
insert into product values ('Product 1', '2022-12-02', 200);
insert into product values ('Product 2', '2022-12-01', 200);
insert into product values ('Product 2', '2022-12-03', 500);
insert into product values ('Product 3', '2022-12-04', 300);
insert into product values ('Product 3', '2022-12-08', 600);
insert into product values ('Product 4', '2022-12-01', 100);
insert into product values ('Product 4', '2022-12-03', 100);
insert into product values ('Product 5', '2022-12-01', 700);
insert into product values ('Product 5', '2022-12-10', 800);
insert into product values ('Product 6', '2022-12-01', 600);
insert into product values ('Product 6', '2022-12-10', 100);

INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1


SELECT product, date, value
FROM product
GROUP BY product, date, value
ORDER BY SUM(value) DESC 
FETCH FIRST 3 ROWS WITH TIES;


product
date
value


Product 5
2022-12-10
800

Product 5
2022-12-01
700

Product 3
2022-12-08
600

Product 6
2022-12-01
600



SELECT 4


SELECT product, date, value 
FROM product 
WHERE product IN 
(SELECT product
FROM product
GROUP BY product
ORDER BY SUM(value) DESC 
FETCH FIRST 3 ROWS WITH TIES)
ORDER BY product, date;


product
date
value


Product 2
2022-12-01
200

Product 2
2022-12-03
500

Product 3
2022-12-04
300

Product 3
2022-12-08
600

Product 5
2022-12-01
700

Product 5
2022-12-10
800

Product 6
2022-12-01
600

Product 6
2022-12-10
100



SELECT 8


SELECT product, date, value 
FROM product 
WHERE product IN 
(SELECT product
FROM product
GROUP BY product
ORDER BY SUM(value) DESC, product 
LIMIT 3)
ORDER BY product, date;


product
date
value


Product 2
2022-12-01
200

Product 2
2022-12-03
500

Product 3
2022-12-04
300

Product 3
2022-12-08
600

Product 5
2022-12-01
700

Product 5
2022-12-10
800



SELECT 6

product	date	value
Product 5	2022-12-10	800
Product 5	2022-12-01	700
Product 3	2022-12-08	600
Product 6	2022-12-01	600

product	date	value
Product 2	2022-12-01	200
Product 2	2022-12-03	500
Product 3	2022-12-04	300
Product 3	2022-12-08	600
Product 5	2022-12-01	700
Product 5	2022-12-10	800
Product 6	2022-12-01	600
Product 6	2022-12-10	100