LeetCode - 购买了产品A和产品B却没有购买产品C的顾客

14.购买了产品A和产品B却没有购买产品C的顾客

链接:https://leetcode-cn.com/problems/customers-who-bought-products-a-and-b-but-not-c/

--使用连接的方法
select c.customer_id, customer_name 

from customers c left join orders o

on c.customer_id = o.customer_id

group by c.customer_id

having sum(product_name