MySQL 8.0

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

select version();


version()


8.0.30


CREATE TABLE preliminar (
  day_dt date NOT NULL,
  location_id int,
  type_id int,
  other_id int);

INSERT INTO preliminar 
    (day_dt, location_id,type_id, other_id) 
VALUES 
    ('2021-01-01',1, 22, 3),
    ('2021-01-01',1, 22, 5),
    ('2021-01-01',2,  1, 1),
    ('2021-01-15',2,  1, 1),
    ('2021-01-22',1,  22, 1),
    ('2021-02-01',1,  1, 1),
    ('2021-02-01',1,  22, 1);

Records: 7  Duplicates: 0  Warnings: 0


;

Query was empty


SELECT *, COUNT(*) OVER(PARTITION BY location_id, type_id, YEAR(day_dt), MONTH(day_dt)) counts
FROM preliminar
ORDER BY day_dt


day_dt
location_id
type_id
other_id
counts


2021-01-01
1
22
3
3

2021-01-01
1
22
5
3

2021-01-01
2
1
1
2

2021-01-15
2
1
1
2

2021-01-22
1
22
1
3

2021-02-01
1
1
1
1

2021-02-01
1
22
1
1

day_dt	location_id	type_id	other_id	counts
2021-01-01	1	22	3	3
2021-01-01	1	22	5	3
2021-01-01	2	1	1	2
2021-01-15	2	1	1	2
2021-01-22	1	22	1	3
2021-02-01	1	1	1	1
2021-02-01	1	22	1	1