zOs/SQL/CATTSCLO

select clone, instance, cln, inst, count(*)
    from sysibm.sysTablespace s
    left join
       (select           'N', 1, 1, '-' from sysibm.sysDummy1
        union all select 'Y', 1, 1, 'B' cl from sysibm.sysDummy1
        union all select 'Y', 1, 2, 'C' cl from sysibm.sysDummy1
        union all select 'Y', 2, 1, 'C' cl from sysibm.sysDummy1
        union all select 'Y', 2, 2, 'B' cl from sysibm.sysDummy1
       ) i (sC, sI, inst, cln)
       on s.clone = i.sC and s.instance =  sI
    group by clone, instance, cln, inst