with t as(
select 1 s,1 l,1 p from dual
union all
select 1,2,1 from dual
union all
select 1,3,1 from dual
union all
select 2,1,1 from dual
union all
select 2,2,1 from dual
union all
select 2,4,1 from dual
union all
select 3,5,3 from dual
union all
select 3,6,3 from dual
union all
select 3,1,2 from dual
)
select * from t

S	1	2	3
1	0	2	2
2	1	1	2
3	3	1	0

with t as(
select 1 s,1 l,1 p from dual
union all
select 1,2,1 from dual
union all
select 1,3,1 from dual
union all
select 2,1,1 from dual
union all
select 2,2,1 from dual
union all
select 2,4,2 from dual
union all
select 3,1,1 from dual
union all
select 3,4,2 from dual
union all
select 3,5,3 from dual
)

select * from (
select a.s,a.p from (
select * from (select distinct l,p from t),(select 1 s from dual union all select 2 from dual union all select 3 from dual)) a,t
where (a.s=t.s(+) and a.l=t.l(+) and a.p=t.p(+))
and t.p is null) z pivot(count(*) for p in('1','2','3'))