SELECT
customer_id
FROM table
GROUP BY name
HAVING SUM(is_black=0)=0 AND SUM(is_black=1)!=0
Простой
