用sql查询出名下的所有卡的状态都是disable的用户名

sql问题：查询一张表，表如图。
要查询出名下的所有卡的状态都是disable的用户名
方法多种？

 select * from cards A WHERE A.NAME NOT IN (select b.name from cards B WHERE B.status = 'able')
 

select status
from card
where status = “disbale”

select name
from cards
where name not in(
select name
from cards
where status!=status
)

SELECT * FROM
(SELECT name, GROUP_CONCAT(DISTINCT status )  AS all_status
FROM cards
GROUP BY name)  AS a
WHERE a.all_status = 'disable';