一、题目
二、代码
# Write your MySQL query statement below
-- select count(distinct product_key ) from Product as number
select table1.customer_id from
(
select customer_id ,count(distinct product_key) as co1 from Customer
group by customer_id
) as table1
join
(
select count(distinct product_key ) as co2 from Product as number
) as table2
where table1.co1 = table2.co2