MySQL 8.0

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

CREATE TABLE test (ID INT, createdDate DATE, productId INT, customerId INT);
INSERT INTO test VALUES
(1   ,'2020-01-01'   ,       1       ,       1       ),
(1   ,'2020-01-01'   ,       2       ,       2       ),
(1   ,'2020-01-01'   ,       3       ,       1       ),
(1   ,'2020-01-01'   ,       4       ,       3       ),
(1   ,'2020-01-01'   ,       5       ,       2       ),
(1   ,'2020-01-01'   ,       4       ,       3       ),
(1   ,'2020-08-01'   ,       3       ,       1       ),
(1   ,'2020-08-02'   ,       6       ,       1       ),
(1   ,'2020-05-01'   ,       3       ,       1       );
SELECT * FROm test;


ID
createdDate
productId
customerId


1
2020-01-01
1
1

1
2020-01-01
2
2

1
2020-01-01
3
1

1
2020-01-01
4
3

1
2020-01-01
5
2

1
2020-01-01
4
3

1
2020-08-01
3
1

1
2020-08-02
6
1

1
2020-05-01
3
1


select
    sum(if(t.createdDate> TIMESTAMPADD(DAY, -20, NOW()),1,0)) newer,
    sum(if(t.createdDate< TIMESTAMPADD(DAY, -20, NOW()),1,0)) older
from test t where customerId=1 group by productId


newer
older


0
1

1
2

1
0


select sum(if(newer=1,1,0)) newerCount, sum(if(newer=0 and older>0,1,0)) olderCount
from (
select
    sum(if(t.createdDate> TIMESTAMPADD(DAY, -20, NOW()),1,0)) newer,
    sum(if(t.createdDate< TIMESTAMPADD(DAY, -20, NOW()),1,0)) older
from test t where customerId=1 group by productId) result


newerCount
olderCount


2
1

ID	createdDate	productId	customerId
1	2020-01-01	1	1
1	2020-01-01	2	2
1	2020-01-01	3	1
1	2020-01-01	4	3
1	2020-01-01	5	2
1	2020-01-01	4	3
1	2020-08-01	3	1
1	2020-08-02	6	1
1	2020-05-01	3	1