Skip to content

1398. Customers Who Bought Products A and B but Not C 👍

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SELECT
  customer_id,
  customer_name
FROM Customers
INNER JOIN Orders
  USING (customer_id)
GROUP BY 1
HAVING
  SUM(Orders.product_name = 'A') > 0
  AND SUM(Orders.product_name = 'B') > 0
  AND SUM(Orders.product_name = 'C') = 0;