SQL CASE的THEN语句中的多个值

这有点丑陋，但假设HeadQuarters不是十进制/数字类型，而只是整数值，

AND L.HeadQuarters BETWEEN CASE WHEN (SELECT COUNT...) = 1 THEN 0 ELSE 1 END AND 1;