带有IN和SELECT子查询的CASE(CASE with IN and SELECT subquery)

 我想在CASE逻辑中使用Select子查询执行IN语句（MySQL方言一直在使用） 
 
 所以查询的想法是这样的： 
 
select a.client_id,
(case when a.client_id in (select distinct a.client_id from account a
where a.display_name='b') then '1' else '0' end) as binary
from account a
group by a.client_id
order by a.client_id
 
 它显示错误，所以我想知道它是如何被替换和重写的？ 
 
 谢谢！ 

I want to perform IN statement with a Select subquery in a CASE logic (MySQL dialect's been using)
 
So the idea of the query is like this:
 
select a.client_id,
(case when a.client_id in (select distinct a.client_id from account a
where a.display_name='b') then '1' else '0' end) as binary
from account a
group by a.client_id
order by a.client_id
 
It shows error, so I'm wondering how it can be replaced and rewritten? 
 
Thanks!

原文：