Postgres 13

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

create table table_name(target_date date, type varchar(10))
insert into table_name values
('2020-10-01', 'type1'),
('2020-10-01', 'type1'),
('2020-10-01', 'type1'),
('2020-10-01', 'type1'),
('2020-10-01', 'type1'),
('2020-10-01', 'type1'),
('2020-10-01', 'type1'),
('2020-10-02', 'type1'),
('2020-10-02', 'type1'),
('2020-10-02', 'type1'),
('2020-10-02', 'type2'),
('2020-10-02', 'type2'),
('2020-10-02', 'type2'),
('2020-10-02', 'type2'),
('2020-10-02', 'type2'),
('2020-10-02', 'type2'),
('2020-10-03', 'type1'),
('2020-10-03', 'type1'),
('2020-10-03', 'type1'),
('2020-10-03', 'type1'),
('2020-10-03', 'type1'),
('2020-10-03', 'type1'),
('2020-10-03', 'type1')
23 rows affected

SELECT dates.target_date, types.type, COUNT(t.target_date)
FROM (
  SELECT DISTINCT target_date
  FROM table_name
) dates
CROSS JOIN (
  SELECT DISTINCT type
  FROM table_name
) types
LEFT JOIN table_name t ON t.target_date = dates.target_date AND t.type = types.type
GROUP BY dates.target_date, types.type
ORDER BY dates.target_date, types.type


target_date
type
count


2020-10-01
type1
7

2020-10-01
type2
0

2020-10-02
type1
3

2020-10-02
type2
6

2020-10-03
type1
7

2020-10-03
type2
0

target_date	type	count
2020-10-01	type1	7
2020-10-01	type2	0
2020-10-02	type1	3
2020-10-02	type2	6
2020-10-03	type1	7
2020-10-03	type2	0