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

This is a little ugly, but assuming HeadQuarters is not a decimal/numeric type and only integer values,

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