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 )

);