with k(b, a, c, cunq) as(
select b, a, count(a), count(distinct a)
  from t
 where a in (11,22,37)
 group by grouping sets(b, (b,a))
) 
, "Интригал"(a, b, c) as (
select a, b, 1e38
  from k where a is null and cunq = 3
union all 
select k.a, k.b, case i.c when 1e38 then k.c else i.c-1 end
  from "Интригал" i, k
 where i.b = k.b 
   and nvl(i.a, k.a) = k.a 
   and i.c > 1
)
select a,b 
  from "Интригал" 
 where a is not null
;

with "Интригал"(b, ta) as(
select b, cast(collect(a) as SYS.ku$_ObjNumSet) t
  from t
 group by b
having 3 = cardinality(cast(collect(a) as SYS.ku$_ObjNumSet) multiset intersect distinct SYS.ku$_ObjNumSet(11,22,37))
)
select column_value a, b 
  from "Интригал", table(ta)
;

with "Интригал"(b, ta) as(
select b, cast(collect(a) as SYS.ku$_ObjNumSet) t
  from t
 where a in (11,22,37)
 group by b
having 3 = cardinality(cast(collect(a) as SYS.ku$_ObjNumSet) multiset intersect distinct SYS.ku$_ObjNumSet(11,22,37))
)
select column_value a, b 
  from "Интригал", table(ta)
;

with "Интригал"(b, ta) as(
select b, cast(collect(a) as SYS.ku$_ObjNumSet)
  from t
 where a in (11,22,37)
 group by b
having SYS.ku$_ObjNumSet(11,22,37) multiset except cast(collect(a) as SYS.ku$_ObjNumSet)  = SYS.ku$_ObjNumSet()
)
select column_value a, b
  from "Интригал", table(ta)
;