当前位置 博文首页 > 好好学习天天向上:leetcode-Database-1083|销售分析II
not in
select distinct buyer_id
from Sales s join Product p on s.product_id=p.product_id
where p.product_name='S8'
and buyer_id not in
(select buyer_id
from Sales s join Product p on s.product_id=p.product_id
where p.product_name='iPhone')
cs