Something
public text v1 · immutableselect CustomerID from plans where
(
(select count(planID) from plans X where X.CustomerID=CustomerID) =
( select count(planid) from plans Y where Y.Customerid=Customerid and Y.Closed=0 )
);
select CustomerID from plans where
(
(select count(planID) from plans X where X.CustomerID=CustomerID) =
( select count(planid) from plans Y where Y.Customerid=Customerid and Y.Closed=0 )
);