只是另一个可能的查询，它构建了计划列表，成员被订阅并检查计划是否不在该列表中-

with temptable as 
( 
  select acct,collect_list(plans) as plan_list
  from plantable
  group by acct
)
select * from temptable  
where array_contains(plan_list,'planA') = false;

尝试

select * from accplans a
where a.acct not in
  (select a2.acct from accplans a2 where a2.plans = 'planA')

显而易见的解决方案是使用自连接。连接是代价高昂的操作。你可以尝试另一种方法。

SELECT acct, 
       SUM(CASE WHEN plans='planA' THEN 1 ELSE 0 END) AS hasPlanA
  FROM tbl
 GROUP BY acct
HAVING hasPlanA = 0

通过上面的陈述，您实际上是在计算一个客户订阅plana的次数。这个 HAVING 子句只过滤plana订阅为零的结果。