SQLite 3.16

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

create table table1
(
creationdate date,rule varchar(100),position int
);
insert into table1(creationdate,rule ,position)
values
('01.01.2018','squid:S1132',12),
('01.01.2018','squid:S1132',14),
('01.01.2018','squid:S1132',20),
('01.01.2018','squid:S1121',21),
('01.01.2018','squid:S1121',14),
('01.02.2018','squid:S1130',21)
select 
   creationDate, 
   count(case when rule='squid:S1132' then "creationDate" end) as "squid:S1132",
   count(case when rule='squid:S1121' then "creationDate" end) as "squid:S1121" ,
   count(case when rule='squid:S1130' then "creationDate" end) as "squid:S1130" 
from table1 
group by creationDate


creationdate
squid:S1132
squid:S1121
squid:S1130


01.01.2018
3
2
0

01.02.2018
0
0
1