select count(distinct p.productid) as "product count"
from customers c
inner join orders o
on c.customerid = o.customerid
inner join orderdetails od
on o.orderid = od.orderid
inner join products p
on od.productid = p.productid
where c.country = 'USA'