red.snapper

red.snapper

HomeArchives

[leetcode-cn] 1045-customers-who-bought-all-products

#leetcode41
AI-generated summary
This query selects the customer IDs of customers who have bought all products. It joins the Customer and Product tables on the product key and groups the results by customer ID. It then filters the results to only include customers who have bought all distinct products.

https://leetcode.cn/problems/customers-who-bought-all-products/

SELECT c.customer_id
FROM Customer c
INNER JOIN Product p
ON c.product_key = p.product_key
GROUP BY c.customer_id
HAVING COUNT(DISTINCT(c.product_key)) = (SELECT COUNT(product_key) FROM Product)
Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.