hard20 pts · first answer countssqlgroup-byaggregation

Customers who bought every item in a set

Which query finds customers who bought all three of products 101, 102 and 103, even if they bought some of them more than once?

A.WHERE product_id = 101 AND product_id = 102 AND product_id = 103 GROUP BY customer_id HAVING COUNT(*) >= 1B.WHERE product_id IN (101,102,103) GROUP BY customer_id HAVING COUNT(*) = 3C.WHERE product_id IN (101,102,103) GROUP BY customer_id HAVING COUNT(DISTINCT product_id) = 3D.WHERE product_id IN (101,102,103) GROUP BY customer_id HAVING MAX(product_id) = 103

Discussion 0

Join free to post in the discussion.

Customers who bought every item in a set

Discussion 0

Related questions